Cannot connect to SQL Server 2000 through client

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Excel 009 - 19 Jul 2008 05:46 GMT

I have a SQL Server set up as Windows Authentication. I am trying to
use another PC (client) to connect to the server, but kept getting the
following message:

A connection could not be established to XXX (the server name)

Reason: Login failed for user 'XXX\Guest'

Please verify SQL Server is running and check your SQL Server
registration properties....

The SQL Server is running for sure because I can access it using
Enterprise Manager on the server.

Please help.

Reply to this Message

Linchi Shea - 19 Jul 2008 15:34 GMT

First, check in the errorlog what network protocols the server is listening on.

For instance, towards the beginning of the errorlog, it may say something
like the following {the following was taken from SQL2005. But SQL2000 should
be similar):

Server is listening on [ 172.16.76.162 <ipv4> 50000].
Server named pipe provider is ready to accept connection on [
\\.\pipe\$$\NYCSQL01\sql\query ].

Then, ping the IP from the client if teh srever listens on the IP.
Try to connect to the IP and the port with osql from the client:

cmd>osql -S172.16.76.162,50000 -Uabc -Pabc

If that all works, try connecting with the network name instead of IP:

cmd>osql -SNYCSQL01,50000 -Uabc -Pabc

This should help narrow the issue down.

Linchi

> I have a SQL Server set up as Windows Authentication. I am trying to
> use another PC (client) to connect to the server, but kept getting the
[quoted text clipped - 11 lines]
>
> Please help.

Reply to this Message