Network / Instance Related Issue

[Zondre]

I am setting up a new site and I am having an issue connecting to the database. I know that I can't use SqlExpress for the production environment. And, I purchsed a SQL2008 database when I signed up. I uploaded the data and tables using a script file. I removed the reference to "LocalSqlServer" and added the new production connection string. But, I am still getting the following error -
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Does any one have any other ideas?

Mahalo,
Zondre

[wisemx]

Hi,
Have you tried the [Clear, Add, Remove] features that help prevent this?
Pasted below is an example, notice how the Add and Remove parts work:

<connectionStrings>
<clear />
<remove name="LocalSqlServer" />
<add name="LocalSqlServer" connectionString="Data Source=tcp:sql.discountasp.net;Initial Catalog=SQL_numid_account;User ID=SQL_numid_user;Password=pw_here"
providerName="System.Data.SqlClient" />
<add name="SQL2005_msftwise_userConnectionString" connectionString="Data Source=tcp:sql.discountasp.net;Initial Catalog=SQL_numid_account;User ID=SQL_numid_user;Password=pw_here"
providerName="System.Data.SqlClient" />
</connectionStrings>