Solved

[Microsoft][ODBC SQL Server Driver] Communication Link Failure (#0)

Posted on 2011-03-16
2
913 Views
Last Modified: 2012-05-11
[Microsoft][ODBC SQL Server Driver] Communication Link Failure (#0)
Any ideas about this error?
0
Comment
Question by:tesla764
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 4

Accepted Solution

by:
rocky_lotus_newbie earned 500 total points
ID: 35150784
This indicates the connection problems (mostly network) to sql server from the client.

Are you able to ping (or Telnet SQL Port) the SQL Server from client? Do you have ping timeouts?
It is possible that the SQL server is extreemely busy (CPU and Memory Pegging) and is dropping the connection.
Please provide more details of how are you trying to connect to the Server.

Thanks,
0
 

Author Closing Comment

by:tesla764
ID: 35151013
I think we're ok with this now.
Thanks
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

695 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question