MSSQL 2005 connection strings

[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...

[Paul Image-Machine]

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