• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 386
  • Last Modified:

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.
0
Nilesh Roy
Asked:
Nilesh Roy
1 Solution
 
r_a_j_e_s_hCommented:
Ping the main server from destination where u r getting that error
0
 
Nilesh RoySenior Manager - Technology ManagementAuthor Commented:
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.
0
 
andrewbleakleyCommented:
Have you enabled Named Pipes and TCP/IP ? Which do you use by default ?
0
 
Eugene ZCommented:
what do you try to do?
please post details
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now