Welcome Guest, Login

Page History: Received Error: SQL Server does not exist or access is denied

Compare Page Revisions

58 57 56 55 54 53 52 51 50 49 48 47 46 45 44 43 42 41 40 39 38 37 36 35 34 33 32 31 30 29 28 27 26 25 24 23 22 21 20 19 18 17 16 15 14 13 12 11 10 9 8 7 6 5 4 3 2 1 0 Current 58 57 56 55 54 53 52 51 50 49 48 47 46 45 44 43 42 41 40 39 38 37 36 35 34 33 32 31 30 29 28 27 26 25 24 23 22 21 20 19 18 17 16 15 14 13 12 11 10 9 8 7 6 5 4 3 2 1 0

« Older Revision - Back to Page History - Newer Revision »

Page Revision: Tue, 15 Dec 2009 20:58

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

1. 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
   
   
2. 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:

1. Go to Start>Run.
2. Type CMD then press enter. This will bring up the command line.
3. 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:

1. Open the CW Admin.exe.
2. 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