Last post Jul 06, 2012 09:15 PM by Decker Dong - MSFT
Jul 04, 2012 07:44 PM|steveitglobal|LINK
I recently uploaded my site in which i created to display data from my database. after running the site, it gave me the following error.
Server Error in '/' Application.
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)
Can anyone give me a hint on what to do please. my current connection string is data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=App_Data\aspnetdb.mdf;User Instance=true.
Please I need help
Jul 04, 2012 08:30 PM|jsiahaan|LINK
Create a temporary web application project on VS2010, and at the web.config you can find a connectionString contain aspnetdb.mdf, modify your connectionString like the connectionString from this temporary project.
Jul 06, 2012 09:15 PM|Decker Dong - MSFT|LINK
Please check whether the instance name of your SQL Server is "SQLEXPRESS" or not.
Maybe you can try this way——
source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\aspnetdb.mdf;User Instance=true