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

CosmogHong-MSFT 23,556 Reputation points Microsoft Vendor

2024-05-02T06:03:06.72+00:00

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".
Please sign in to rate this answer.

0 comments No comments
Sign in to comment
Erland Sommarskog 102.1K Reputation points MVP

2024-05-02T21:25:45.0033333+00:00
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.
Please sign in to rate this answer.
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 102.1K Reputation points MVP

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 102.1K Reputation points MVP

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 102.1K Reputation points MVP

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.
Sign in to comment

Share via

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

2 answers