Forum Discussion

HalfADimePlural's avatar
HalfADimePlural
New Contributor
4 years ago

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.

Data-Driven Testing
  • Marsha_R's avatar
    Marsha_R
    Moderator
    4 years ago

    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.

    • HalfADimePlural's avatar
      HalfADimePlural
      New Contributor
      4 years ago

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

Recent Discussions