Showing posts with label pro. Show all posts
Showing posts with label pro. Show all posts

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.

Wednesday, March 7, 2012

Help - problem with running SQL Server Management Studio Express CTP

I just installed SQL Server Management Studio Express CTP on a new XP Pro machine. SSMSECTP is present in the program list but nothing happens when I select it. What do I do to fix this? I don't have any type of interface to the SQL Server databases, although the Configuration Manager works OK.Problem solved - I uninstalled everything except MS .NET Framework 2.0 and then reinstalled everything. After this SSMSECTP came up OK.