CAREWare should always work with the newest version of Microsoft SQL Server and the latest patch, so upgrading to the latest SQL Server Version and patch is recommended. Though CAREWare can run on SQL Server 2016 or newer, we recommend running CAREWare on newer versions of SQL Server (At least SQL Server 2022 or newer) for security and support reasons.

Some CAREWare installations are managed by IT departments that handle the SQL Server for the organization. If that is the case, staff for the organization should get guidance from the IT department staff. If the organization lacks an IT department that can help with acquiring SQL Server, there are two choices: buying SQL Server and installing the free SQL Express.

As a rule of thumb, for small to medium sized providers with 10 or fewer users, SQL Express should be fine, because it limits databases to 10GB and it only runs on one processor. For larger CAREWare installations the full version of the SQL Server should be installed. 

Note: The Standard Edition is all that CAREWare needs, however it also works with the Web and Enterprise editions.

 

To obtain the latest version of SQL Express, start here:

https://www.microsoft.com/en-us/sql-server/sql-server-2019

Some non-profit providers have reported that they have obtained the full version of SQL Server with user licenses at a deep discount through Tech Soup, but larger institutions may not qualify. You can get the details here:

 

http://www.techsoup.org/

You can also get more information on the full version of SQL server at this link:

 

https://www.microsoft.com/en-us/sql-server

If you have questions, please contact the CAREWare Help Desk.

The latest patch for SQL Server can be downloaded here

Some versions of SQL Server are no longer updated or supported by Microsoft. Click here to review the lifecycle of SQL Server by version.