在localhost上通过TCP / IP连接到SQL Server 2000失败

时间：2022-10-19 18:57:44

I have tried to connect to SQL Server 2000 through TCP/IP.

我试图通过TCP / IP连接到SQL Server 2000。

I followed these steps and enabled SQL Server 2000 on port 1433.

我按照这些步骤在端口1433上启用了SQL Server 2000。

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?

如何解决这个问题并通过TCP / IP连接到Sql Server 2000？

See my configs

看我的配置

在localhost上通过TCP / IP连接到SQL Server 2000失败在localhost上通过TCP / IP连接到SQL Server 2000失败

5 个解决方案

#1

1  

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。您需要运行SQL Server配置管理器 - > SQL Server网络配置并启用该协议，然后重新启动SQL Server服务

#2

1  

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.

编辑：等等，您是否在客户端或服务器上启用了TCP / IP？如果您只在客户端上启用它，那就解释了它。

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.

必须在两者上启用它才能进行通信。从您的错误看，服务器似乎不接受TCP连接。我不记得SQL 2000调用该程序，但发现类似“SQL Server网络配置”，而不是“客户端配置”。并在那里打开TCP。

Perhaps show us a screenshot of your network configuration dialog.

也许向我们展示一下您的网络配置对话框的截图。

#3

1  

I did following actions to remove this bug

我做了以下操作来删除此错误

1)Disable Other Protocols other than TCP/IP from SQL Server Client And Server Utilities

1）从SQL Server客户端和服务器实用程序禁用TCP / IP以外的其他协议

2)Re-Instal SQL Server 2000 sp4

2）重新安装SQL Server 2000 sp4

#4

0  

I think you need to be running SQL Server Agent to connect via TCP/IP on 2000.

我认为您需要在2000上运行SQL Server代理以通过TCP / IP进行连接。

#5

0  

This behavior is by design: http://support.microsoft.com/kb/929152

此行为是设计使然：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:

使用本地主机地址名称的替代表示形式而不是“localhost”。可能的替代表示包括以下内容：

  • 127.0.0.1
  • 127.0.0.1
  • "."
  • “”
  • The actual local host name
  • 实际的本地主机名

#1

1  

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。您需要运行SQL Server配置管理器 - > SQL Server网络配置并启用该协议，然后重新启动SQL Server服务

#2

1  

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.

编辑：等等，您是否在客户端或服务器上启用了TCP / IP？如果您只在客户端上启用它，那就解释了它。

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.

必须在两者上启用它才能进行通信。从您的错误看，服务器似乎不接受TCP连接。我不记得SQL 2000调用该程序，但发现类似“SQL Server网络配置”，而不是“客户端配置”。并在那里打开TCP。

Perhaps show us a screenshot of your network configuration dialog.

也许向我们展示一下您的网络配置对话框的截图。

#3

1  

I did following actions to remove this bug

我做了以下操作来删除此错误

1)Disable Other Protocols other than TCP/IP from SQL Server Client And Server Utilities

1）从SQL Server客户端和服务器实用程序禁用TCP / IP以外的其他协议

2)Re-Instal SQL Server 2000 sp4

2）重新安装SQL Server 2000 sp4

#4

0  

I think you need to be running SQL Server Agent to connect via TCP/IP on 2000.

我认为您需要在2000上运行SQL Server代理以通过TCP / IP进行连接。

#5

0  

This behavior is by design: http://support.microsoft.com/kb/929152

此行为是设计使然：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:

使用本地主机地址名称的替代表示形式而不是“localhost”。可能的替代表示包括以下内容：

  • 127.0.0.1
  • 127.0.0.1
  • "."
  • “”
  • The actual local host name
  • 实际的本地主机名
标签：

相关文章