Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Our application is running on dozens of servers and only a few get this error message. What is worse, is that the SQL query that causes this error message seems to be executing. The application is working properly. The process that causes this error is a perl script running on a Windows Server 2003 box. The database is hosted on the same machine. This is the SQL that causes the error:

Update [WorkQueue]
    set [Status] = ?
    where [id] in
        select top 1 [id] from [WorkQueue]
        where [Status] = 1 order by [id] ASC

We use ODBC to connect to the SQL Server 2005 database with TCP/IP on port 1433. The problem is that this error, "Communication link failure (SQL-08S01)", is being reported about three times a minute. Should I try switching to named pipes for my connection protocol?

share|improve this question

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.