A network-related or instance-specific error occurred while establishing a connection to SQL Server

asp.net database vb.net sql-server-2005 aspnetdb
ClixNCash picture ClixNCash · Jan 19, 2011 · Viewed 8.5k times · Source

I HOST MY ASP.NET WEBSITE ON WEBSERVER ..But after upload when i try to access my site ...

http://www.vbi.volvobusesindia.com

Then following error occurs ....

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)

i have changed my connectionstring in web.config file and all webpages to : 

<connectionStrings>
    <remove name="ConnectionString"/>
    <add name="ConnectionString" connectionString="Data Source=69.16.253.19,1433; Network Library=DBMSSOCN; Initial Catalog=database;Persist Security Info=True;User ID=username;Password=password" providerName="System.Data.SqlClient"/>
  </connectionStrings>

...before publishing and uploading my website to webserver ...

I m confused the problem is from my local computer or the webserver ....and how to fix this error ?

Answer

3Dave picture 3Dave · Jan 19, 2011

This means that your web server can't connect talk to the SQL server. Are you sure that the IP is correct, and that the SQL server is configured to accept remote connections over IP?

Can you connect to the database server using SQL Management Studio, using the same username, password and IP address that are in your connection string? Is your application retrieving the correct connection string from web.config?

Related questions

"The transaction log for database is full due to 'LOG_BACKUP'" in a shared host

I have an Asp.Net MVC 5 website with EntityFramework codefirst approach in a shared hosting plan. It uses the open source WebbsitePanel for control panel and its SQL Server panel is somewhat limited. Today when I wanted to edit the …

Read More
Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints

I make an outer join and executed successfully in the informix database but I get the following exception in my code: DataTable dt = TeachingLoadDAL.GetCoursesWithEvalState(i, bat); Failed to enable constraints. One or more rows contain values violating non-null, unique, …

Read More
Unable to cast object of type 'System.DBNull' to type 'System.String`

I got the above error in my app. Here is the original code public string GetCustomerNumber(Guid id) { string accountNumber = (string)DBSqlHelperFactory.ExecuteScalar(connectionStringSplendidmyApp, CommandType.StoredProcedure, "GetCustomerNumber", new SqlParameter("@id", id)); return accountNumber.ToString(); } I replaced with public string GetCustomerNumber(…

Read More