Showing posts with label udl. Show all posts
Showing posts with label udl. Show all posts

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.

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.