ASP.NET sites gave SQL Error: 26 – Error Locating Server

Asked By sharonfaviles 40 points N/A Posted on - 08/09/2012

Hi experts,

I get the following error message when I am trying to deal with ASP.NET or ASP sites.

I need to solve it. I need your help. Please.

Thanks.

OnASP.NET sites I get this “Server Error – Error: 26 – Error Locating Server/Instance Specified”

Server Error in '/YourApps' 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)

Error: Server Error – Error: 26 – Error Locating Server/Instance Specified

• Status: Open
• Question Views: 1472
• Answer Count: 4
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: .NET Programming

Best Answer by Carl Jack

Go To Solution

Best Answer

Best Answer

Answered By Carl Jack 10 points N/A #139761

ASP.NET sites gave SQL Error: 26 – Error Locating Server

Hallo Sharon,

You should check your server and see if it is accessible and also make sure that the Remote Access from the SQL server has been turned on.

Also check the following:

• You should ensure that the server name you are using is correct; make sure there are no misspellings.
• Ensure that the instance name you are using is correct, and make sure that you actually have an instance on the target machine.
• Check your machine and see if the firewall is enabled. If so, you will need to put sqlbrowser.exe and/or UDP port 1434 into the exception.
• You need to ensure that the server machine can be reached, that is, its DNS can be resolved without a problem.

Hope this helps.

Regards,

Carl

About Carl Jack

Questions
1

Answers
1657

Best Answers
417

• Vote Up 0 Vote Down

• Posted on - 08/09/2012
• Question Category: .NET Programming

Answered By Jamy Orther 0 points N/A #139762

ASP.NET sites gave SQL Error: 26 – Error Locating Server

Ensure that you have configured your connection string well in web config file in your project so it must look like this:

Where name means the name of your connection string and connection string hold your connection string details like data source that holds the location of your database and initial catalog that holds your database name and integrated security that mean you are using windows or SQL authentication.

If you are using SQL authentication you will need to provide a username and password inside connection string data and provider name that holds your database dll library name

Regards,

About Jamy Orther

Questions
1

Answers
15

Best Answers
5

• Vote Up 0 Vote Down

• Posted on - 08/09/2012
• Question Category: .NET Programming

Answered By Toni Linscomb 5 points N/A #139763

ASP.NET sites gave SQL Error: 26 – Error Locating Server

Error simply means that your application is trying to access the SQL Server database and it’s not accessible.

If your database system tries in your local system below options.

Check the services on your computer system and make sure that the MSSQL instance is started.

If you have any passwords assigned to the SQL Server account make sure to mention the password on your application connection string.

<add name="PinCBusMgtDocs.Properties.Settings.PINCConnectionString"

connectionString="Data Source=WWPPINCS;Initial Catalog=PinCBusMgtDocs;User ID=sa;Password=123"

providerName="System.Data.SqlClient" />

Make sure your server name and the database name is correctly mentioned in the application connection string.

About Toni Linscomb

Questions
0

Answers
197

Best Answers
86

• Vote Up 0 Vote Down

• Posted on - 11/05/2012
• Question Category: .NET Programming

Answered By saa222 20 points N/A #139764

ASP.NET sites gave SQL Error: 26 – Error Locating Server

Hi Sharon,

First of all, be sure whether your server is accessible or not and then be sure to turn on Remote Access from the SQL server and then you should check the following thing:

 

# Be sure of using the server name correctly and be aware of misspellings.

# Be sure of using the instance name correctly and also be sure of the fact that the target machine has an instance.

# Whether firewall is enabled on your machine, should be checked. And put sqlbrowser.exe and/or UDP port 1434 into the exception.

# If the server machine is reached, should be ensured, which means that its DNS is solvable without hazard.

 

Hope that this message will help you.

About saa222

Questions
2

Answers
2

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 01/07/2013
• Question Category: .NET Programming