SQL Server错误“命名管道提供者:无法打开与SQL Server [53]的连接". [英] SQL Server Error "Named Pipes Provider: Could not open a connection to SQL Server [53]"

问题描述

我曾经有一个桌面应用程序，该应用程序通过具有以下连接字符串的.ini文件指向Sybase数据库:

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""

效果很好.

几天前，数据库已迁移到SQL Server 2008 R2，我需要更新.ini文件以重定向新的生产服务器.我更新了连接字符串，如下所示:

A few days ago the database has been 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 follow:

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

但是出现以下错误:

命名管道提供者:无法打开与SQL Server [53]的连接

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

其他说明:

• 生产DNS在其他IT领域运行正常，其他应用程序也可以毫无问题地到达服务器.
• 我正在尝试通过开发箱进行连接.
• 该应用程序是一个继承了多年的实现，这就是*.ini文件需要保留的原因.

• Production DNS is working perfectly in other IT areas and other apps are reaching the server without troubles.
• I'm trying to connect from dev box.
• The application is an inherited implementation with several years, that's why the *.ini file needs to be kept around.

我花了几个小时浏览互联网以获取错误详细信息，但几乎没有结果.

I've some hours browsing internet for error details with almost no results.

新的连接字符串看起来正确吗?关于会产生错误的原因有什么想法?建议?

Does the new connection string seems correct?. Any idea of what can be generating the error? Recommendations?

预先感谢

推荐答案

幸运的是，在挖掘了几个小时之后，我被告知存在一个生产DNS错误导致了我的问题.

Fortunately after digging around for several hours I have been told there is a production DNS error that was causing my issue.

我通过在数据源连接属性上提供服务器名称来解决此问题，如下所示:

I fixed the issue by providing the server name on the Data Source connection attribue as follow:

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

提示 :为避免服务器名称出错，您可以通过执行以下T-SQL通过SQL Server Management Studio将其检出:

Tip: to avoid errors on server name you can check it out through SQL Server Management Studio by executing the following T-SQL:

SELECT @@servername

这篇关于SQL Server错误“命名管道提供者:无法打开与SQL Server [53]的连接".的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！