Forum Discussion

endorium79's avatar
endorium79
New Contributor
2 months ago
Solved

DB connection fails when run in a test

I have the below function. When I run the function on its own, it passes everytime. When I run this function in a scripted test, it fails everytime with the error 'Cannot open database "BDS.SynergyPl...
  • endorium79's avatar
    endorium79
    2 months ago

    I solved it in the end. It was the WS2 IP. It wasn't resolving properly

scot1967's avatar
scot1967
Icon for Champion Level 2 rankChampion Level 2
2 months ago


Good morning from Missouri,  🤠  LOL

Could you verify/send a copy of the connectionString value as well?  I am curious about the project variables when run in each circumstance.    (Just **** out the user and password) but do verify they are correct.  😉 

 var connectionString =
      "Provider=MSOLEDBSQL;" +
      "Data Source=" + Project.Variables.SQLServer + ";" +
      "Initial Catalog=BDS.SynergyPlusWfm.Working;" +
      "User ID=" + Project.Variables.SQLUser + ";" +
      "Password=" + Project.Variables.SQLPassword + ";" +
      "Encrypt=true;" +
      "TrustServerCertificate=true;" +
      "Persist Security Info=True;";

... If you find my posts helpful drop me a like! 👍 Be sure to mark or post the solution to help others out and/or to credit the one who helped you. 😎