Page History: Received Error: SQL Server does not exist or access is denied
Compare Page Revisions
Page Revision: Tue, 15 Dec 2009 20:46
This error message has two resolutions. In order to resolve this error you will need to go to the business tier directory and open the CW Admin utility.
The business tier directory is located by default at C:\Program Files\CAREWare\RW CAREWare Business Tier
- a) Click on the “Services” tab and verify that the SQL Server instance is started and running.
b) If it is not, then highlight the instance (default name is MSSQL$CAREWare) and then click “Start Service”.
OR
- a) Click on the “Server Settings” tab in the CW Admin utility
b) Click on DatabaseConnectionString
c) Click on the "Edit" button. This will allow you to view the entire string.
d) You will need to verify that the hostname and SQL Server instance name are correct in the DatabaseConnectionString. The hostname\instancename will appear as "server=hostname\instanceName; initial catelog=CW_Data;"
To find the computer hostname:
# Go to Start>Run
# Type CMD then press enter. This will bring up the command line.
# From the command line type HOSTNAME and then press enter. The name displayed is the hostname for the computer you are currently using.
To find the SQL Server instance name:
# Open the CW Admin.exe
# Go to the Services tab and view the MSSQL$XXXXX (where X is the name) service.
By default this should display as MSSQL$CAREWare.
Return to
Frequently Asked Questions