Thursday, February 16, 2012

Can't connect to SQL on 2000 from Windows Server 2003

This is weird, I can connect to a sql server from a windows 2000 server (UDL, Query Analyzer, ect.), but cannot connect from a Windows 2003 box.
Anyone else experience this? Could there be an MDAC version issue?
Please help,
thanks.
Try creating a test ODBC DSN to connect and reply back with the exact error
message.
You need to get the OS error to resolve this.
Example: OS Error 10061 == Connection Refused.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
|||I got the same problem, but after install the Client Tools, the Enterprise
Manager says timeout.
Same prob when trying to create a DNS to check connection.
Still Eror: 0 SQLSTATUS: HYT00 Timeout
|||Timeout issues may be resolve simply by increasing the LoginTimeout Value
in Enterprise Manager. The default value is 4 seconds which may be too
short.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

No comments:

Post a Comment