Server Error in '/' Application

While have seen other forum questions/knowledgebase articles on this error, I have been unable to resolve it.
The problem occurs on my production website when I try to browse a page in a private directory. The page request properly redirects me to my Login Page. However, when I enter the login/password I get the database error "An error has occurred while establishing a connection to the server. (error 26).

Steps that I have taken to try to resolve the issue.
1. I added the MS SQL2005 database and had it provisioned.
2. I uploaded my website to the discountasp.net website. My application used SQLExpress to create the login database called ASPNETDB.MDF. This database file was uploaded into \root\App_Data.
3. I went into the MS SQL2005 SQL Tool and "Attached" the ASPNETDB.MDF file. The webpage reported "Attach Successful".
4. I modified the web.config file in my root directory with the following connectionString statement:
<connectionStrings>
<add name="ConnectionString1" connectionString="Data Source=tcp:sql2k510.discountasp.net;Initial Catalog=SQL2005_414709_oasis1;Persist Security Info=True;User ID=SQL2005_414709_oasis1_user;Password=******"
providerName="System.Data.SqlClient" />
</connectionStrings>

I replaced the password with asterisks for security purposes.

Several conversations with Discountasp.net's tech support have met with no resolution.

Any help would be appreciated.

 

Cancel Post. Found the answer in another thread

Your connectionstring should look as follows:

<remove name="LocalSqlServer"/>
<add name="LocalSqlServer" connectionString="Data Source=sql2k509.discountasp.net;Integrated Security=False;Initial Catalog=SQL2005_xxxxxx_xxxx;User ID=SQL2005_xxxxxx_xxxx;Password=xxxxxx" providerName="System.Data.SqlClient"/>
<add name="BooksConnectionString" connectionString="Data Source=sql2k509.discountasp.net;Integrated Security=False;Initial Catalog=SQL2005_xxxxxx_xxxx;User ID=SQL2005_xxxxxx_xxxx;Password=xxxxxx" providerName="System.Data.SqlClient"/>

Please fill ithe missing information in the above connection string,which can be found in you MS SQL 2005 Manager in your DASP control panel.



This information was posted by VVSHARMA. Thank you. You ended several hours of frustration. It was the addition of the "LocalSqlServer" lines that cleared the problem.