Getting error of Named Pipes in sql during distributed query execution

Question

1.00/5 (1 vote)

See more:

SQL-Server-2008

Hi everyone,

I have just made a distributed query which queries two server database , i have linked both sql server using linked server storedprocedure and i have also enabled Named pipes , disabled firewall , enabled tcp/ip connection.

but when i run the query

I get error of Named pipes..

Please help me how to resolve this error.

Thanks & Regards,
Krunal Panchal

Posted 27-Apr-11 5:37am

krunal25

Add a Solution

Comments

Sergey Alexandrovich Kryukov 27-Apr-11 11:52am

Do you think "I get error" can tell anything? How can you imaging answering the question?
--SA

[no name] 28-Apr-11 0:37am

Hello,
I am sorry that i have not included the whole of the error, but the error is as follows:
Named Pipes Provider: Could not open a connection to SQL Server [53].
I am not sure why i am getting this error, i have enabled everything like Named Pipes , Tcp/Ip etc.

Please help me out,
Regards,
Krunal panchal

Sandeep Mewara 27-Apr-11 12:23pm

What error?

[no name] 28-Apr-11 0:37am

Hello,
I am sorry that i have not included the whole of the error, but the error is as follows:
Named Pipes Provider: Could not open a connection to SQL Server [53].
I am not sure why i am getting this error, i have enabled everything like Named Pipes , Tcp/Ip etc.

Please help me out,
Regards,
Krunal panchal

Sandeep Mewara 28-Apr-11 0:39am

You mean you have configured surface area configuration?

RDBurmon 28-Apr-11 2:27am

Please share the query with us .

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)

thatraja · Answer 1 · 2011-05-01T16:56:00

Here you go

winerr 53 means "The network path was not found". If you got this message, it means the client stack cannot find the target machine. Here are possible reasons for this failure,
a) typo in the server name, or using "/" rather than "\" between server name and instance name, e.g. "myserver/myinst" is not correct.
b) name resolution to the server name is not correct, "ping -a yourserver" would tell if that's the case
c) The server machine is firewall'ed and file sharing is not in the exception list. You need put "File and Printer Sharing" in exception. (from below link)

Named Pipes Provider, error: 40 - Could not open a connection to SQL Server (Microsoft SQL Server, Error: XXX)[^]

SQL SERVER – FIX : ERROR : (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server) (Microsoft SQL Server, Error: )[^]