Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

 
discard

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

Browse other questions tagged or ask your own question.