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 deniedI 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