26 - Error Locating Server/Instance Specified

Hi,

Have installed the club site starter kit on my pc and all it works well locally. I've used visual studio to publish my site to my third party webhost. Ive created the DB on their server and altered the connection string to:-

<

connectionStrings><!--<add name="ClubSiteDB" connectionString="Server=xx.xx.xx.xx;Database=somedatabasename;User ID=user;Password=Password;Trusted_Connection=False" providerName="System.Data.SqlClient"/>-->

</

connectionStrings>

Now its on the webhosts server i get a System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified).

This occurs when im trying to login in or register.

Can any one help.

Hi Ballantyne

This one usally means that your connection string is wrong - what to do is create a txt file on the web server and then rename it test.udl - now double click it and put in the details to the server and make sure you can connect to the database using the details your storing in your connection string.

Cheers
Gregor

|||

First make sure your connection string is correct.

CheckSQL Server Troubleshooting to set everything properly.

If problem still exists make sure no firewall blocks your connection.

Hope it helps.