Link to home
Start Free TrialLog in
Avatar of Nilesh Roy
Nilesh RoyFlag for India

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.
Avatar of r_a_j_e_s_h
r_a_j_e_s_h

Ping the main server from destination where u r getting that error
Avatar of Nilesh Roy

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.
Have you enabled Named Pipes and TCP/IP ? Which do you use by default ?
Avatar of EugeneZ
what do you try to do?
please post details
ASKER CERTIFIED SOLUTION
Avatar of EugeneZ
EugeneZ
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial