March 5, 2002 at 2:20 am
I get the error "[Microsoft][ODBC SQL Server Driver]Timeout Expired" when I try to connect to a remote database on my SQL Query Analyzer. I can't even create an ODBC DSN on any remote database because I get the same error. I have SQL Server 2000 Client Tools installed on my pc. My OS is Windows 2000 Professional.
Please help. Thanks.
March 5, 2002 at 4:24 am
When you are creating the DSN what screen is it failing at? Also based on another conversation a user change from TCP/IP to Multiprotocol and tried (which failed) then change the connection type back and the problem went away, could you give that a try and see it you get the same results?
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
March 5, 2002 at 9:00 am
Can you ping the server name? IP address? Sounds like a connectivity issue. I've even seen times where SQL would not accept connections - look for errors relating to listening on port xxx in the error log.
Andy
March 5, 2002 at 7:07 pm
quote:
When you are creating the DSN what screen is it failing at? Also based on another conversation a user change from TCP/IP to Multiprotocol and tried (which failed) then change the connection type back and the problem went away, could you give that a try and see it you get the same results?"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Hi Antares686,
On creation of a DSN, it fails on the screen where you type in the username and password. It won't pass through that screen, but instead shows the error. I also tried changing from TCP/IP to Multiprotocol and vice versa, the problem did not go away.
What else can I do? Are we running out of options?
March 5, 2002 at 7:10 pm
quote:
Can you ping the server name? IP address? Sounds like a connectivity issue. I've even seen times where SQL would not accept connections - look for errors relating to listening on port xxx in the error log.Andy
Hi Andy,
Yes, I can ping the server. The connection actually works fine on my Enterprise Manager. It just fails on creation of DSN and on the SQL Query Analyzer.
What else do I have to check?
Thanks.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply