Unable to connect to my Attached SQL Express 2005 DB!! Please Help!

Discussion in 'Databases' started by dubai, Dec 20, 2009.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. I have attached my SQL2005 Express Database to my web application, and edited the Web.config file as required. However, I still get connection problems to my database. and here is the error message:

    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).Net SqlClient Data Provider
     
  2. Hi,

    This error usually indicates that your application is trying to connect to a SQL Express database, which you mentioned you are using in your post. We do not support SQL Express database on our server.

    You will have to upsize your SQL Express Database to a SQL 2005 or SQL 2008 database and change the web.config file connection string to point the SQL server.
     
  3. mjp

    mjp

    Or attach it to your SQL 2005 database using the tool here.
     
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page