March 11, 2006 at 11:31 pm
Hi All,
When I try to connect to SQL server using Server name, connection is established from Query Analyzer. However when I try to connect using I.P address, then the following error is rasied.
"ODBC: Msg 0, Level 16, State 1 [Microsoft] [ODBC SQL Server Driver] Timeout expired"
Can any one give some pointers where could be the problem?
Cheers,
Mani
March 13, 2006 at 6:56 am
Are you trying to connect to a 'default' or a 'named' instance ? Have you set up any 'aliases' ?
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
March 13, 2006 at 10:44 am
Connecting by name you are likely using Named Pipes. The sql server needs to have TCP/IP enabled before you can connect by IP address.
March 13, 2006 at 10:56 am
It was a network issue. Restarting DNS server resolved the issue.
Thanks
Mani
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply