Hosted by You
(See SQL Server and VPN Setup cost below)
VPN Method
- Requires a server (like Windows 2003 or 2008) that allows Routing & Remote Access
- Install Procare licensing server and database server on your server
- Install VPN client software on client computers (standard XP/Vista client or 3rd party)
- Install Procare client software on client computers
- Costs – Server & IT Hours, plus internet VPN appliances if a hardware VPN is used
- Tech Needed? – Yes (see also: bandwidth recommendations below)
Terminal Services Method
- Requires a server and Terminal Services software, licenses
- Install Procare licensing server, database server AND client software all on your server
- Install Terminal Services client software on client computers
- Costs – Server, TS licenses & IT Hours
- Tech Needed? - Yes
- Compatible with a Check-In Computer? - Yes. See article Check In with Terminal Services.
Bandwidth
Minimum available bandwidth for hosted data: 1.5 mbs/1,500 kbps (download) and 512 kbps (upload). Wireless AirCards® (3G, 4G, etc.) are NOT supported.
Important! If classroom cameras or other devices/programs share your bandwidth you may not have enough "available" bandwidth for Procare to run effectively. Make sure you have enough total bandwidth to accommodate all your needs.
Self Hosted Costs
SQL Server & VPN setup cost (Hosted By You)
The cost detail below is an example for 1 corporate office, 5 locations with 2 users at each location, depending upon the size of each location.
| Software / OS Cost |
Unit Cost |
Qty |
Total |
Recurring SA Cost |
| Microsoft Windows Server 2008 Standard |
$694 |
1 |
$694 |
|
| Microsoft Windows Server 2008 SA |
$353 |
1 |
$353 |
$353 |
| Microsoft Windows Server 2008 1 user Cal |
$40 |
10 |
$400 |
|
| Microsoft Windows Server 2008 1 user Cal SA |
$37 |
10 |
$370 |
$370 |
| |
|
|
|
|
| Microsoft SQL Server 2008 Standard |
$864 |
1 |
$864 |
|
| Microsoft SQL Server 2008 Standard SA |
$436 |
1 |
$436 |
$436 |
| Microsoft SQL Server 2008 Standard 1 user Cal |
$160 |
10 |
$1,600 |
|
| Microsoft SQL Server 2008 Standard SA |
$83 |
10 |
$830 |
$830 |
| |
|
|
|
|
| Hardware |
|
|
|
|
Base HP Proliant ML110 Tower, 2.4Ghz Core2Duo
1 Gig Ram, 2x160G Sata hard Drives, $25.00 Shipping |
$750 |
1 |
$750 |
|
| |
|
|
|
|
| VPN Cost - ISP charges vary with bandwidth |
|
|
|
|
| Basic VPN: Lower Security/Firewall cost |
|
|
|
|
| Hosting Location |
$120 |
1 |
$120 |
|
| Remote Location |
$120 |
5 |
$600 |
|
| |
|
|
|
|
| Total Server Cost (Hardware & Software): |
|
|
$6,297 |
|
| Recurring SA cost every 3 years: |
|
|
$1,989 |
|
| Total VPN Hardware |
|
|
$720 |
|
| 4 hours Server IT labor @ $100/hr |
|
|
$400 |
|
| 2 hours VPN IT labor @ $100/hr |
|
|
$200 |
|
| Total: |
|
|
$9,006 |
$1,989.00/3 years |
Notes
- Cal: Client Access License of which there are 2 types - either per User of per Device (computer)
- SA: Software Assurance
- Prices obtained from CDW 5/09 and HP 3/09
SQL Server Express, a free product based on SQL Server 2005 technology, may be used instead of SQL Server. It uses the same reliable and high-performance database engine as the other versions of SQL Server 2005. It also uses the same data access APIs such as ADO.NET, SQL Native Client, and T-SQL. In fact, it is differentiated from the rest of the SQL Server 2005 editions only by the following:
http://msdn.microsoft.com/en-us/library/ms345154.aspx
- Lack of enterprise features support
- Limited management tools
- Limited to one CPU
- One GB memory limit for the buffer pool
- Databases have a 4 GB maximum size