View Single Post
  #1 (permalink)  
Old August 26th, 2011, 11:44 AM
grouchy grouchy is offline
Registered User
Points: 19, Level: 1
Points: 19, Level: 1 Points: 19, Level: 1 Points: 19, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Aug 2011
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default Single database for ASPNETDB.mdf and database.mdf

I have deployed both db from the App Data file to a single database. The data from the database.mdf is accessible but the ASPNETDB is throwing errors. Specifically "26 Error locating server/instance" I have worked through the security, deployment and Appendix B (3.5) but no joy as yet and varied everything I can think of.

here is the webconfig. The provider uses SQL Server authentication.

Code:
<configuration>
  <connectionStrings>
    <clear/>
    <add name="ConnectionString" connectionString="Data Source=213.171.201.131; Initial Catalog=Firstdb; User ID=xxxx;       Password=xxxx;" providerName="System.Data.SqlClient"/>
    <remove name="LocalSqlServer"/>
    <add name="LocalSqlServer" connectionString="Data Source=213.171.201.131; Initial Catalog=Firstdb; User ID=xxxx;         Password=xxxx;" providerName="System.Data.SqlClient" />
  </connectionStrings>
  <system.web>
    <customErrors mode="Off"/>
    <roleManager enabled="true"/>
    <authentication mode="Forms"/>
  </system.web>
</configuration>
Reply With Quote