SQL Server 2008 连接失败

发布于 2024-10-29 01:31:02 字数 776 浏览 3 评论 0原文

我家里有两个互联网连接（假设 A 和 B），使用两个不同的调制解调器/路由器。我正在使用 Sql Server 2008 Express 客户端连接远程 Sql Server 2008 服务器实例。

当我使用互联网连接 A 时，我可以轻松连接，但不能使用连接 B。它向我显示下面给出的错误...

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: TCP
Provider, error: 0 - A connection attempt failed because the connected party did not
properly respond after a period of time, or established connection failed because connected
host has failed to respond.) (.Net SqlClient Data Provider)

除了这个问题之外，两个连接都工作得很好。我认为这是防火墙问题并尝试禁用它们，但结果相同。还尝试在连接属性中指定 TCP/IP、命名管道，但没有成功。

请帮忙。

原文

I have two internet connections (let's say A and B) at my home using two different modem/routers. I am using Sql Server 2008 Express client to connect with a remote Sql Server 2008 server instance.

I can connect easily when I use my internet connection A but never with connection B. It shows me an error given below ...

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: TCP
Provider, error: 0 - A connection attempt failed because the connected party did not
properly respond after a period of time, or established connection failed because connected
host has failed to respond.) (.Net SqlClient Data Provider)

Other than this issue, both connections work perfectly fine. I assumed this to be a firewall issue and tried disabling them but with same result. Also tried specifying TCP/IP, Named Pipes in connection properties but in vain.

Please help.

分享到QQ

分享到微博