MS SQL Server远程连接问题 [英] MS SQL Server Remote Connection Problems

问题描述

嘿伙计们，

这可能是MS SQL Server用户常见的问题，但我的问题与许多论坛上解释的许多类似问题有点不同。

我有远程服务器上的SQL服务器数据库，每当我尝试使用LAN（与服务器在同一网络上的其他计算机）访问数据库时我能够连接但是当我尝试使用其他网络如调制解调器时我得到了以下错误：

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

我试过在防火墙例外允许端口1433然后关闭防火墙但问题仍然存在。

当我尝试使用LAN网络telnet端口1433时似乎成功但是当我使用调制解调器网络时它拒绝连接。

我使用在线工具来telnet端口1433但状态显示它已关闭。我检查了我的网络管理员，他们说他们允许端口1433通过中央防火墙，所以问题可能在我的服务器上。

我的假设是网络基础设施禁止1433端口，但如果问题在我的服务器上，它是什么？因为我可以通过局域网访问。

任何帮助将不胜感激。

解决方案

如果你可以在局域网中使用它，为什么你可以使用公共IP。找到公共IP并将其连接到连接字符串。



或者您可以使用公共IP服务器（在WAN中），您可以使用SSMS访问数据库

Hey guys,
This might be a common problem to MS SQL Server users but my problem is a bit different from many of the similar problem explained on many forums.
I have SQL server database located on remote server, whenever I tried to access the database by using LAN(other computer on the same network with server) I'm able to connect but when I try to use other network such as modem I got the following error:
"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) (Microsoft SQL Server, Error: 53)"
I have try to allow port 1433 on firewall exception then turn off firewall but the problem continues.
When I try to telnet the port 1433 by using LAN network it seems to success but when I'm using modem network it refuse connection.
I used online tools to telnet port 1433 but the status showed that it is closed. I checked with my network administrator they said they allow port 1433 through central firewall so the problem might be on my server.
My assumption is that network infrastructure prohibit 1433 port but if the problem is on my server, what is it? as I'm able to access through the LAN.
Any help will be appreciated.

解决方案

If u can use it in LAN, How come you can use it with Public IP. find the public IP and connect it in Connection string.

Or you can take the server with Public IP (in WAN) and you can use the SSMS to access the DB.

这篇关于MS SQL Server远程连接问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！