Showing posts with label explaine. Show all posts
Showing posts with label explaine. Show all posts

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.

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.