Wednesday, March 21, 2012

HELP CANT CONNECT TO SQL SERVER ON WIN XP PRO

I am having connection issues with SQL 2k on my win XP pro box. I had no problems last week but now I cant do anything.
I read many kb articles about problems with SP 2 and SQL 2k and nothing seems to help. Has anyone had any similiar problems? I need to access my remote sql server for a client and I have been dealing with this problem for the last week with no solution? I believe I have opened up every possible port the SQL will use. I followed all of the kb articles and still nothing.
Thanks

Can you give us more detail on the "connection issues"? Are youreceiving any error messages? If so, these will go a long waytowards helping you to resolve the problem.
|||

Sure, in enterprise manager when I click on one of my server nodes it try to connect to the site.

The error I get is
A connection could not be established to xyz server
Reason: SQL Server does not exist or access denied
ConnectionOpen (Connect()...)
I was able to connect to this server last week with no issues. I have tired 5 different servers and I cant connect to any of them. I am running windows xp pro service pack 2 and sql 2k.

|||One thing you could do is to check the logs under Data folder.

No comments:

Post a Comment