can help ? (web.config)

Sep 6, 2010 at 8:53 AM
Edited Sep 6, 2010 at 12:07 PM

hi, I downloaded your sourcecode for studying, nice application. 

I have one question, I noticed Nerddinner using ".\SQLEXPRESS" as data source in web.config.  For my application, I'm also using ".\SQLEXPRESS" as data source in web.config. When I upload to website(webhosting), I got this 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)

how does NerdDinner work without error:26?   I checked your web.config. there is no much differece with mine. Confused  .

I do really appreciate your help! thanks!


    <add name="ApplicationServices" connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true" providerName="System.Data.SqlClient" />
    <add name="TestStoreEntities" connectionString="metadata=res://*/Models.StoreDB.csdl|res://*/Models.StoreDB.ssdl|res://*/Models.StoreDB.msl;provider=System.Data.SqlClient;provider connection string=&quot;Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\MvcTestStore.mdf;Integrated Security=True;User Instance=True;MultipleActiveResultSets=True&quot;" providerName="System.Data.EntityClient" />