Saturday, February 25, 2012

Cllient Unable to establish connection

Hi Am using a SQL 2k server and have been regularly logging into other SQL 2K servers in the network using the SQL Query Analyser/Enterprise Manager. After suffering a BSD yesterday, unable to log in to any server from my Query Analyser/Enterprise Manager - get this error: "Client Unable to Establish Connection".
Others are also not able establish connection - they get a General Network error when trying to connecting to my server.
Think the Blue screen death corrupted some SQL driver in the process. Now am apprehensive about uninstalling and re-installing the SQL server since am unable to backup the databases.
Can anybody help please?SQL 2k?

I find it very unlikely...did you bounce the box?

Did and admin revoke your rights?

Blue screen of death? Haven;'t seen that in a loong while.

What o/s and what patches?|||SQL 2K with SP 3. Running on Win 2k (SP4) Server. There has been no change in the admin rights. it just stopped working after the crash.
that's why its confusing.. not much help from Miscrosoft either.

Originally posted by Brett Kaiser
SQL 2k?

I find it very unlikely...did you bounce the box?

Did and admin revoke your rights?

Blue screen of death? Haven;'t seen that in a loong while.

What o/s and what patches?|||Check your Client Config utility ? Try creating an alias using TCP/IP ..

What SQl Client you are using from where you accessing SQL Server ..?|||Tried the Client Network Utility - the TCP/IP option is not enabled when i try to add an alias. Only the Multiple Protocol, Apple Talk, VIA and "Other" options are enabled.
The server is installed in my laptop and am accessing from the same machine using the SQL Query Analyser. The laptop is a Win2k Server (SP4).

Originally posted by aashu
Check your Client Config utility ? Try creating an alias using TCP/IP ..

What SQl Client you are using from where you accessing SQL Server ..?

No comments:

Post a Comment