All geek questions in one place

SQL Server Error "Named pipe providers: Could not open connection to SQL Server [53]"

I used to have a desktop application pointing to a Sybase database through an .ini file that had this connection string:

  CONNECTION_NAME = "DSN="Dna_Name";UID="User";PWD="Password""

This worked perfectly.

A few days ago, the database was migrated to SQL Server 2008 R2, and I need to update the .ini file to redirect the new production server. I updated the connection string as follows:

 CONNECTION_NAME = "Provider=SQLNCLI10.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog="CatalogName";Data Source="Production_DNS""

But I get the following error:

Named Pipe Provider: Could not open a connection to SQL Server [53]

Additional notes:

  • DNS products work well in other areas of IT, and other applications reach the server without problems.
  • I am trying to connect from dev.
  • An application is a legacy implementation with several years, so the *.ini file must be supported.

I have several hours browsing the Internet to get detailed error information, with almost no results.

Is the new connection string correct ?. Any idea on what might cause the error? Recommendations?

Thanks in advance,

+5
source share
2 answers

Fortunately, after digging a few hours, I was told that there was a DNS error in production that was causing my problem.

I fixed the problem by specifying the server name in the data source connection attribute as follows:

 CONNECTION_NAME = "Provider=SQLNCLI10.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog="CatalogName";Data Source="Production_Server_Name;""

Tip . To avoid errors in the server name, you can verify it through SQL Server Management Studio by running the following T-SQL:

 SELECT @@servername
+6
source

You are probably pointing to the wrong server. I got the same error as linux server.

0
source

Source: https://habr.com/ru/post/1215171/

More articles:


All Articles