Ask a Question

SQL Server does not exist or access denied after server change

New Contributor

SQL Server does not exist or access denied after server change

We retired our old test server for a new one and I'm now getting this error "[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied." despite updating the connection string to match the new server. This was working before we switched servers so I have no clue what's causing the problem. Using connection string format DRIVER={SQL Server};SERVER=[server name];UID=[valid SQL Server login];PWD=[valid SQL Server pwd for server];DATABASE=[initial DB to connect to]. I've confirmed the user and password work through SSMS and I've got no clue what the problem could be. Using VBScript.

Community Hero

When you verified the user/pw through SMSS, did you do it between the actual TC machine and the database server?  I'm interested to see if that connection has been proven out.

[Community Hero]
[Community Heroes] are not employed by SmartBear Software but
are just volunteers who have some experience with the tools by SmartBear Software
and a desire to help others. Posts made by [Community Heroes]
may differ from the official policies of SmartBear Software and should be treated
as the own private opinion of their authors and under no circumstances as an
official answer from SmartBear Software.
The [Community Hero] signature is used with permission by SmartBear Software.

Yes, I'm able to connect and query using the credentials from the TC machine

Showing results for 
Search instead for 
Did you mean: