The connection name 'LocalSqlServer' was not found in the applications configuration

Hi, I had that site working in the past in DASP. But I stop my account hosting and now I am back. My site is working in local, but I am having the error below on my DASP site. Since I do not have access to the machine.config, I do not know what I should do. Any idea?

Server Error in '/' Application.
--------------------------------------------------------------------------------

Configuration Error
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: The connection name 'LocalSqlServer' was not found in the applications configuration or the connection string is empty.

Source Error:


Line 281: <providers>
Line 282: <add name="AspNetSqlRoleProvider" connectionStringName="LocalSqlServer" applicationName="/"
Line 283: type="System.Web.Security.SqlRoleProvider, System.Web, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
Line 284: <add name="AspNetWindowsTokenRoleProvider" applicationName="/"
Line 285: type="System.Web.Security.WindowsTokenRoleProvider, System.Web, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />


Source File: C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config\machine.config Line: 283


--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.1

 

Hi,
Change your conn string so it Clears, Removes and then Adds..Like this:

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

 

issue resolved!

Thanks, I put that inside my connection string tag, just before my real MS access connection string and it's working.
Even if I am not using any SQLlocal, it seems that I have to put the loalsql connection string, even with that dummy username & password...

Anyway, my site is working now, thanks!

 

...Very cool ;-)