Skip to content
  • There are no suggestions because the search field is empty.

Problems connecting to SQL 2005: SQL Server does not exist or access denied

When I configure the OPC Data Logger to connect to a SQL Server 2005 Database, I get the following error:

SQL Server does not exist or access denied

I know and have double-checked the following:

  • database is up and running
  • specified database name is correct
  • username and password are correct

One possible problem may be that the TCP/IP protocol is disabled in the SQL Server 2005 Configuration Manager. Changing the setting from disabled to enabled may solved the problem with connecting from OPC Data Logger to SQL Server.

If this does not help, the following link contains a wealth of troubleshooting steps for this specific error message, which can apply to any SQL Client connecting to the database and is not a specific problem of the Data Logger:

http://blogs.msdn.com/sql_protocols/archive/2005/10/29/486861.aspx