Named Pipes Provider: Could not open a connection to SQL Server

Question

Named Pipes Provider: Could not open a connection to SQL Server

Raja Raju 0

Hi,

Named Pipes Provider: Could not open a connection to SQL Server error (53)

from public facing Server to Local SQL Server but Local to DMC Server possible

Please any one can you advice to me

Kind Regards

R.Raja

2 answers

Your answer

Answer 1

LiHongMSFT-4306 31,566

Hi @Raja Raju

Named Pipes Provider: Could not open a connection to SQL Server error (53)

Seems like a connecting issue.

Please refer to below tech doc to troubleshoot connectivity issues.

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

Best regards,

Cosmog Hong

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Answer 2

Erland Sommarskog 121.8K MVP Volunteer Moderator

Typically that means that you were not able to reach the SQL Server instance you were trying to reach. There could be any number of reasons for this:

SQL Server is not running.
Misspelling of the server and/or instance name.
Firewalls in the way.

And the list goes on.

You can try this troubleshooter.

Raja Raju 0 Reputation points

2024-05-03T08:13:02.73+00:00

Dear Support,

pls can you help me to solve this issue. I can't fix the problem.

Kind Regards,

R.Raja
Erland Sommarskog 121.8K Reputation points MVP Volunteer Moderator

2024-05-03T21:19:36.4333333+00:00

Dear Support, pls can you help me to solve this issue. I can't fix the problem.

This is not a support desk. It is a peer-to-peer forum. We don't have access to your environment, so we can't say exactly what is wrong, but we can only give information for troubleshooting. And even if this was a support desk, we would not know much, because we know very little what you are doing.

It is seems like you are setting up a ODBC source. Then we would need to see all steps. Can you connect with SSMS?
Raja Raju 0 Reputation points

2024-05-05T15:02:09.0566667+00:00

Dear Suppoer,

I have attached the all the steps for ODBC Connect. I am connect from DMC Server to another local Server.

Kind Regards

R.Raja
Erland Sommarskog 121.8K Reputation points MVP Volunteer Moderator

2024-05-05T16:14:33.6166667+00:00

I am not acquainted with DMC Server. Is that a third-party product. Or did you mean DMZ Server?

Are you able to connect to SQL Server by other means, for instance SSMS, on the same machine?

Are you able to connect to 10.0.50.44 from other machines?

Given the IP address, I would assume that you are in a corporate environment. It may be better to talk with your IT folks, who have knowledge about your environment - something we don't have here.
Raja Raju 0 Reputation points

2024-05-06T01:48:25.9466667+00:00

Dear Erland,

Sorry DMZ.

In addition to connecting to 10.0.50.44, I can connect to it from other virtual machines (VMs), such as 10.0.50.47. just the DMZ to local VM ODBC issue

Kind Regards

R.Raja
Erland Sommarskog 121.8K Reputation points MVP Volunteer Moderator

2024-05-06T20:43:46.97+00:00

Since I don't know your network topology, I can't assist further. But it sounds like you need to talk to your network people. Maybe there are firewalls that has to be opened.

Share via

Named Pipes Provider: Could not open a connection to SQL Server

2 answers

Your answer