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.