从其他PC访问SQL时，无法从PC连接SQL服务器 [英] Unable to connect SQL server from a PC while it is accessed from other PC

问题描述

我尝试搜索我的问题并找到了很多线程，但所有这些线程都与服务器有关。所有与数据库服务器相关的建议/提示。我有一个托管在VPS上的数据库服务器（SQL Server 2014）。服务器运行正常没有任何问题，并通过互联网从所有计算机正常工作。但是从一台PC上它没有连接。我禁用了防病毒软件，在防火墙上的例外列表中添加了程序，但是我仍然无法连接服务器，而该服务器是从其他PC访问的。这台通过有线互联网连接和操作系统在互联网上连接的PC是Windows 7旗舰版（我称之为服务提供商，并确认他们没有阻止/过滤任何IP）。提前致谢。错误详细信息：



建立与SQL Server的连接时发生与网络相关或特定于实例的错误。服务器未找到或无法访问。验证实例名称是否正确，以及SQL Server是否配置为允许远程连接。 （提供者：命名管道提供程序，错误：40 - 无法打开与SQL Server的连接）



我尝试过：



虽然可以从其他计算机访问该服务器，但这意味着服务器上没有问题，我停止防病毒，在防火墙上允许此程序，并创建允许此规则的规则程序。此外，我们确认他们阻止任何IP的互联网服务提供商（他们没有阻止，它是有线互联网连接）。但问题没有解决，我也没有得到同样类型的前一个问题。以前的所有问题都是如何配置数据库服务器，检查数据库服务器/服务，但它们都不是节点/客户端相关的。

I try to search my problem and found lots of threads, but all of them server related. All suggestion/tips regrading Database Server related. I have a database server (SQL Server 2014) hosted on VPS. Server is running fine without any issue, and working fine from all computer over internet. But from one PC it is not connecting. I disabled antivirus, added program on exception list on firewall,but still I am unable to connect the server, while that server are access from other PC. This PC connecting on internet through cable internet connection and operating system is Windows 7 Ultimate (I called service provider, and confirmed that they are not blocking/filtering any IP). Thanks in advance. Error Details:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

What I have tried:

While that server are accessible from other computer, it means there is no issue on server, I stop antivirus, allow this program on Firewall, and also create a rule for allow this program. And also we confirm internet service provider where they are blocking any IP or not (They are not blocking and it is cable internet connection). But problem not solved and also I am not getting same type of previous question. All of previous question how to configure database server, check database server/service, but none of them are node/client related.

推荐答案

通过WAN网络使用TCP连接命名管道。



配置客户端网络协议 [ ^ ]

Use TCP connections over WAN networks not named pipes.

Configuring Client Network Protocols[^]

这篇关于从其他PC访问SQL时，无法从PC连接SQL服务器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！