连接到slq服务器2000时出现问题 [英] problem connecting to slq server 2000

问题描述

嗨.
我在连接到sql server 2000时遇到问题.
在我们的网络上，有一台名为A37的PC，它运行Windows XP SP2和SQL Server 2000(没有任何实例名称). sql服务器浏览器正在运行.此服务器上也启用了tcp/ip协议.

从另一台名为A24的PC上，我已经通过Visual Studio 2010通过Windows 7连接到此服务器，没有任何问题.

但是，从另一台名为A20的PC上，当我尝试使用同一工具(Visual Studio 2010连接到数据库工具)通过Windows XP SP2连接到此服务器时，发生了错误(找不到服务器或无法访问该服务器).实例名称正确，并且该sql服务器配置为允许远程连接)

如果此错误是由于无法在A37上进行远程连接而导致的，那么为什么要从A24进行连接?

所有计算机上的防火墙均已关闭.

这是当我尝试连接到数据库时的连接信息:
伺服器名称:A37
身份验证:SQL Server身份验证
用户名= arpm
密码= 1234.


请帮帮我.
谢谢.

Hi.
I have a problem with connecting to sql server 2000.
On our network , there is a pc named A37 that running windows xp sp2 and sql server 2000 (without any instance name ) . sql server browser is running . tcp/ip protocol also enabled on this server .

from another pc named A24 , I have connected to this server through windows 7 by visual studio 2010 connect to database tool without any problem .

However ,from another pc named A20 , When I try to connect to this server through windows xp sp2 by the same tool (visual studio 2010 connect to database tool) , an error occured ( the server was not found or was not accessible . verify that that instance name is correct and that sql server configured to allow remote connection)

If this error caused by disability of remote connection on A37 , So Why it connected from A24?

Firewall is off on all computer.

Here is connection info When I try to connect to database:
Server Name : A37
Authentication : Sql server authentication
Username = arpm
Password = 1234.


Please help me .
Thank you.

推荐答案

手动检查两台计算机之间的网络是网络问题.尝试从服务器访问任何文件.如果成功，则尝试连接sql server

Manually check the network between both computers it''s a network issue. try to access any file from server. if you are succeded then try to connect with sql server

这篇关于连接到slq服务器2000时出现问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！