RE: SQL or Server 2003 Authentication Problem?
From: Kevin McDonnell [MSFT] (kevmc_at_online.microsoft.com)
Date: 11/27/03
- Next message: Kevin McDonnell [MSFT]: "RE: How can I secure & encrypt connection to SQL over internet?"
- Previous message: Kevin McDonnell [MSFT]: "RE: Access to a remote SQL server through ISA server"
- In reply to: Melina Barreca: "SQL or Server 2003 Authentication Problem?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
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.
- Next message: Kevin McDonnell [MSFT]: "RE: How can I secure & encrypt connection to SQL over internet?"
- Previous message: Kevin McDonnell [MSFT]: "RE: Access to a remote SQL server through ISA server"
- In reply to: Melina Barreca: "SQL or Server 2003 Authentication Problem?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]