通过本地主机上的 TCP/IP 连接到 SQL Server 2000 失败
我尝试通过 TCP/IP 连接到 SQL Server 2000。
我按照这些步骤并在端口1433上启用了SQL Server 2000。
然后我使用命令测试端口是否打开：
telnet localhost 1433
但是我发现了以下错误：
Connecting To localhost...Could not open connection to the host, on port 1433:
Connect failed
并且我也无法通过以下方式连接到服务器 这些步骤。
如何解决这个问题并通过TCP/IP连接到Sql Server 2000？
查看我的配置
I have tried to connect to SQL Server 2000 through TCP/IP.
I followed these steps and enabled SQL Server 2000 on port 1433.
Then I used the command to test whether the port is opened up:
telnet localhost 1433
But I found the following error:
Connecting To localhost...Could not open connection to the host, on port 1433:
Connect failed
And I also failed to connect to the server by following these steps.
How to solve this problem and connect to Sql Server 2000 through TCP/IP?
See my configs
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（6）
默认情况下 TCP-IP 被禁用。
您需要运行SQL Server配置管理器->SQL Server网络配置并启用协议，然后重新启动SQL Server服务
By default TCP-IP is disabled.
You need run SQL Server Configuration Manager->SQL Server Network Configuration and enable the protocol, then restart SQL Server service
尝试暂时禁用防火墙，看看是否有效果，以隔离问题。
编辑：等等，您是否在客户端或服务器上启用了TCP/IP？如果您仅在客户端上启用它，那就可以解释了。
必须在两者上启用它才能允许通信。从您的错误来看，服务器似乎不接受 TCP 连接。我不记得 SQL 2000 对该程序的称呼，但找到了诸如“SQL Server 网络配置”之类的内容，而不是“客户端配置”。并在那里打开 TCP。
也许可以向我们展示您的网络配置对话框的屏幕截图。
Try disable your firewall temporarily and see if it makes a difference, to isolate the problem.
EDIT: Wait, did you enable TCP/IP on the client or server ? If you only enabled it on the client, then that explains it.
It must be enabled on both to allow communication. From your error, it looks like the server does not accept TCP connections. I don't remember what SQL 2000 calls the program, but find something like "SQL Server Network Configuration", not "Client Configuration". And turn on TCP there.
Perhaps show us a screenshot of your network configuration dialog.
我执行了以下操作来删除此错误
1) 从 SQL Server 客户端和服务器实用程序禁用除 TCP/IP 之外的其他协议
2)Re-安装SQL Server 2000 sp4
I did following actions to remove this bug
1)Disable Other Protocols other than TCP/IP from SQL Server Client And Server Utilities
2)Re-Instal SQL Server 2000 sp4
我认为您需要运行 SQL Server 代理才能在 2000 上通过 TCP/IP 进行连接。
I think you need to be running SQL Server Agent to connect via TCP/IP on 2000.
此行为是设计使然：
http://support.microsoft.com/kb/929152
使用名称的替代表示形式本地主机地址而不是“localhost”。可能的替代表示包括以下内容：
This behavior is by design:
http://support.microsoft.com/kb/929152
Use an alternative representation of the name of the local host address instead of "localhost". Possible alternative representations include the following:
安装了SQL Server 2000 SP4，它解决了我的问题。
Installed SQL Server 2000 SP4 and it solved the problem for me.