Nilesh Roy
asked on
SQL Server Enterprise Manager 2003 [MS Design Tools] - ODBC error:[Microsoft][ODBC SQL Server Driver] Communication link failure
Hi !!
Thanks in advance (as i know i will get my solution here) :o)
I have SQL Server Enterprise Manager 2003.
Scenario:
2 sql servers.
1st (primary) - At ISP
2nd - in office - development server
Both the servers have sam eservice packs & same odbc versions.
I am getting the following error right now.
" [MS Design Tools] - ODBC error:[Microsoft][ODBC SQL Server Driver] Communication link failure "
Can someone help please?
Do you need any other information?
Please revert back immediately.
B'regards & Thanks in advance once again.
Nilesh Roy.
Thanks in advance (as i know i will get my solution here) :o)
I have SQL Server Enterprise Manager 2003.
Scenario:
2 sql servers.
1st (primary) - At ISP
2nd - in office - development server
Both the servers have sam eservice packs & same odbc versions.
I am getting the following error right now.
" [MS Design Tools] - ODBC error:[Microsoft][ODBC SQL Server Driver] Communication link failure "
Can someone help please?
Do you need any other information?
Please revert back immediately.
B'regards & Thanks in advance once again.
Nilesh Roy.
Ping the main server from destination where u r getting that error
ASKER
Hi Rajesh,
The following is the ping response.
Pinging A.B.C.D with 32 bytes of data:
Reply from A.B.C.D: bytes=32 time=265ms TTL=107
Reply from A.B.C.D: bytes=32 time=282ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=282ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=282ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=438ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=282ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=391ms TTL=107
Reply from A.B.C.D: bytes=32 time=344ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=265ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=282ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=282ms TTL=106
Reply from A.B.C.D: bytes=32 time=282ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=282ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=282ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=282ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=282ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=485ms TTL=106
Reply from A.B.C.D: bytes=32 time=282ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=281ms TTL=107
Reply from A.B.C.D: bytes=32 time=281ms TTL=106
Reply from A.B.C.D: bytes=32 time=297ms TTL=106
Reply from A.B.C.D: bytes=32 time=297ms TTL=107
Reply from A.B.C.D: bytes=32 time=282ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=281ms TTL=107
Reply from A.B.C.D: bytes=32 time=281ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=281ms TTL=106
Reply from A.B.C.D: bytes=32 time=265ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=282ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=282ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=360ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=281ms TTL=107
Reply from A.B.C.D: bytes=32 time=328ms TTL=106
Reply from A.B.C.D: bytes=32 time=297ms TTL=106
Reply from A.B.C.D: bytes=32 time=407ms TTL=107
Reply from A.B.C.D: bytes=32 time=328ms TTL=106
Reply from A.B.C.D: bytes=32 time=265ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=313ms TTL=106
Reply from A.B.C.D: bytes=32 time=281ms TTL=107
Reply from A.B.C.D: bytes=32 time=265ms TTL=106
Reply from A.B.C.D: bytes=32 time=265ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=297ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=282ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=282ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=282ms TTL=106
Reply from A.B.C.D: bytes=32 time=282ms TTL=107
Awiting replies / responses from other experts.
B'Regards,
Nilesh Roy.
The following is the ping response.
Pinging A.B.C.D with 32 bytes of data:
Reply from A.B.C.D: bytes=32 time=265ms TTL=107
Reply from A.B.C.D: bytes=32 time=282ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=282ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=282ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=438ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=282ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=391ms TTL=107
Reply from A.B.C.D: bytes=32 time=344ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=265ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=282ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=282ms TTL=106
Reply from A.B.C.D: bytes=32 time=282ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=282ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=282ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=282ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=282ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=485ms TTL=106
Reply from A.B.C.D: bytes=32 time=282ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=281ms TTL=107
Reply from A.B.C.D: bytes=32 time=281ms TTL=106
Reply from A.B.C.D: bytes=32 time=297ms TTL=106
Reply from A.B.C.D: bytes=32 time=297ms TTL=107
Reply from A.B.C.D: bytes=32 time=282ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=281ms TTL=107
Reply from A.B.C.D: bytes=32 time=281ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=281ms TTL=106
Reply from A.B.C.D: bytes=32 time=265ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=282ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=282ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=360ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=281ms TTL=107
Reply from A.B.C.D: bytes=32 time=328ms TTL=106
Reply from A.B.C.D: bytes=32 time=297ms TTL=106
Reply from A.B.C.D: bytes=32 time=407ms TTL=107
Reply from A.B.C.D: bytes=32 time=328ms TTL=106
Reply from A.B.C.D: bytes=32 time=265ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=313ms TTL=106
Reply from A.B.C.D: bytes=32 time=281ms TTL=107
Reply from A.B.C.D: bytes=32 time=265ms TTL=106
Reply from A.B.C.D: bytes=32 time=265ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=297ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=282ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=282ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=266ms TTL=107
Reply from A.B.C.D: bytes=32 time=266ms TTL=106
Reply from A.B.C.D: bytes=32 time=282ms TTL=106
Reply from A.B.C.D: bytes=32 time=282ms TTL=107
Awiting replies / responses from other experts.
B'Regards,
Nilesh Roy.
Have you enabled Named Pipes and TCP/IP ? Which do you use by default ?
what do you try to do?
please post details
please post details
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.