Still having issues with getting a connection to the Azure db.
I have tried using the DSN in the connection string but that has not worked. We have a service account that our application uses to connect to the db. The application has no issue using it but all I get is a 'Failed Login' response. If I add in the domain to the service account I get a message that TC "Cannot open server XXXX.com requested by the login" (ie: the domain of the service account).
Connection string is as follows:
Qry.ConnectionString = "Provider=SQLNCLI11;Password=XXXXXX;User ID=XXXXX;Initial Catalog=Databasename;Data Source=Testdbname.database.windows.net";
DB name is correct (real one not in the above) and I use it every day. No idea why it will not connect.
Additionally - in a TC test I have inherited (actually inherited the entire suite for the application) - in many places I can change parameters and data in the TCs but in one instance the parameter is not being saved properly. The URL should be:
https://test.XXXXX.com/#/
When I try and save the case - TC removes the # and makes it: https://portaltest.XXXXX.com// which is incorrect. Another test - slightly different, but does use the same parameter, keeps the formatting with the /#/.
Any ideas for either of the issues?
Thanks,
Brian
