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

Modified on Mon, 16 Jan 2012 11:53 by CAREWare Help Desk — Categorized as: FAQ

Source: jProgBusiness - [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
Invalid connection string attribute
   at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
   at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, 
DbConnectionPool pool, DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup 
poolGroup)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory 
connectionFactory)
   at System.Data.OleDb.OleDbConnection.Open()
   at jProgBusiness.jBusiness.MSSQLSchemaOperations.TableExists(String TableName)
   at jProgBusiness.jBusiness.jBusinessRemote.InitializeIfNecessary(String btpassword)
An exception occurred while creating the remote object.

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:
    data source=ADAM1\CAREWARE; initial catalog=CW_data; persist security info=False; user id=cwbt;


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.

Back to Errors

Back to Frequently Asked Questions