Newbie Help!!! "SQL Server Does not exist or access denied. Connection Open(ConnectionI())."

  • SQL Database was fully operational Friday. Today it will not start. Not aware of anything obvious that I changed.

    I am using Windows XP Home Service Pack 2 Edition and installed SQL Server 2000 Client. When I tried to register open SQL am getting the following message "SQL Server Does not exist or access denied. Connection Open(ConnectionI())."

    Thanks much in advance..

  • I'm going to assume, since you installed only the SQL client, that the SQL database engine is installed on another server.

    Are you an administrator of that server? If not, is there an admin there that you can get help from?

    Is the server itself running? (if you try and ping the server name, do you get a response?)

    Is the SQL server service running?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Gail has the right idea. My Computer/Manage/Services, check for the MSSQLServer service and see if it's running. You can netstat-a and see if the listener is running.

    Are you connecting locally, meaning the server is on your workstation? If not, then Gail is right, check out the server and see if it's running.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply