Quote:
Originally Posted by Rock
Hi Paul,
Replace "Data Source=91.186.30.8:8443\SQLEXPRESS;" with "Data Source=91.186.30.8\SQLEXPRESS;"
The source should be IP\SQLEXPRESS, also the user name for your database should be something difference than sa as 'SA' = System Administrator 
Or the best solution would be a ticket placed to our support dept. They'll get it everything sorted out for you for sure...
|
Thanks for your help. I raised a ticket and it was responded to at 4 in the morning!
The correct string (for anyone else who reads this) is:
connectionString="Data Source=ServerIpAddress;Initial Catalog=MyDatabaseName;User Id=MyUserId;Password=MyPassword;"/>
The ServerIpAddress sould be just the IP address, without '\SQLEXPRESS'.
I don't know if this applies to anyone else, but it works for me! Thanks again for the help, the support here is excellent.
-Paul