Thursday, March 22, 2012

Can not connect to MS SQL server 2000 with Windows XP

First is can I use Windows XP with the client tools (Enterprise Manager) to
connect to MS SQL Server 2000? If so, can someone explaine? I have tried
using SQL Server Authentication but I get an error saying server does not
exit or access denied. I tried using the SA account and that does not work
either.
Thanks,
Yes you should be able to . One gotcha is that XP Home always
authenticates as Guest.
Create a Test ODBC DSN to get a better error message if you can't connect.
Check the OS error number.
Example:
OS Error 10061 = Connection Refused. Server is not listening on the socket.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

No comments:

Post a Comment