RE: SQL or Server 2003 Authentication Problem?

From: Kevin McDonnell [MSFT] (kevmc_at_online.microsoft.com)
Date: 11/27/03


Date: Thu, 27 Nov 2003 00:30:49 GMT

The client machines have a login timeout value that is not controlled via
Enterprise Manager. Try connecting from the client machine using the ODBC
manager. Choosing the Test button will give you a better error message.
Also, you can try the following from a DOS command window using ISQL.exe

ISQL -Stcp:ServerNameHere -UuserName -Ppassword
or
ISQL -Stcp:ServerNameHere -E

Look for the OS Error number returned. This will tell you why the
connection is failing.

Thanks,

Kevin McDonnell
Microsoft Corporation

This posting is provided AS IS with no warranties, and confers no rights.