Navigation (CAREWare 6)¶

• Main Page
• All CAREWare Documentation
  

• Create a new Page
• All Pages
  

• Administration
• File Management
  

• Create Account
  

Search the wiki
»

CW Admin Database Connection String

CAREWare support and documentation has been moved to a new location. For the most updated user guides and documentation for CAREWare click on the link below:

jPROG CAREWare Support Portal

The CAREWare business tier connects to the database using the database connection string setting stored in the BusinessTierSettings.xml file. The CW Admin utility can be used to edit the database connection string and test the connection between the business tier and the database. The CW Admin utility is located at C:\Program Files\CAREWare Business Tier\CW Admin by default.


To edit the database connection string:

1. Right click CW Admin.
2. Click Run as Administrator.
   
3. Click Stop Server.
4. Click Connection String Management.
5. Click DatabaseConnectionString.
6. Click Edit Selected.
   
   

Server Address – The name of the PC/Server where the CAREWare database instance is installed and the name of the CAREWare database instance.
Database Name – The name of the CAREWare database in the SQL database instance.
SQL login ID – The SQL login that is the database owner for cw_data.
Password – The password for the SQL login ID.
Show – Displays the hidden password for the login.
Encrypt In Settings File – When checked the database connection string is encrypted in the BusinessTierSettings.xml file.
Test Connection – Tests the connection between the CAREWare business tier and the CAREWare database.
Save – Saves changes to the database connection string.
Cancel – Closes Edit Selected without saving changes to the database connection string.


7. Once the database connection string has been edited, click Save.
8. Click Server Settings.
9. Click Start Server.


To test the database connection string:

1. Click Connection String Management.
2. Click Test Connection.
   
   

If there is a connection error, make sure the SQL Server instance service is started and then start the business tier service.

1. Click Services.
2. Click the database instance name under Service Name (i.e. MSSQL$CW6SETUPTEST3).
3. Click Start Service.
4. Click CAREWare Business Tier Service.
5. Click Start Service.
   
   

For any other error, type the error in quick search here or contact the CAREWare Help Desk.


Click here to download these instructions.

For additional instructions for using the CW Admin utility click here.

Instructions for CAREWare Version 5 build 945 or earlier can be downloaded here.

Back to CAREWare 6 and CAREWare 5 Program Administrator FAQ