I am wondering if anyone can help. (This will most likely be a set of yes or no questions)
Essentially, I have got a set of tests which asserts data in a database stored on a SQL server after a given set of UI actions. All of these tests work locally on my machine but not in the test cloud. This is where the test cloud falls over and cannot connect to my SQL Server with the error:
System.Data.SqlClient.SqlException : Server does not exist or connection refused.
My questions are,
Can assertions in the test cloud work with SQL server?
If so, then I am assuming that I will need to make sure that my connection string will need to make use of the IP address of the SQL Server and not the name of it and it's instance? (Also, how do I find the IP address of SQL server?)