Connection to Remote Server in Web Service

Question

0.00/5 (No votes)

See more:

Hi Friends, I have one web service, I have a web method which takes a string as input from a textbox. and outputs a list.

When I tried executing the service I am getting error as Server is not found or Server was not accessible.Verify that Instance name is correct and that SQL is configured to allow remote connections(Provider SQL Netword Interface Error: 26......
).....

I got this error. I have google it and could not find the right solution. I have got one site
http://blogs.msdn.com/b/sql_protocols/archive/2008/04/30/steps-to-troubleshoot-connectivity-issues.aspx

about the errors may occur for SQL Server.

What may be the problem?

Thanks in Advance
Ganesh

Posted 9-May-12 21:43pm

Ganesh KP

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sandeep Mewara · Accepted Answer · 2012-05-09T23:18:00

First and foremost make sure that the SQL Server services are running. Other reasons could be, incorrect connection string
or some Firewall blockage.

Look if the following discussion help: provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance...[^]
This one too: "Specified SQL server not found" o..[^]