SQL 2005 cluster Error

Posted on 2011-04-19
Last Modified: 2012-05-11
Hi All,

  My setup:

SQL 2005 Active/passive

The active node is two IBM 3950 Connected to each others ( Cascading) and the passive is a single server IBM 3920.

I have one SQL job that runs each night, my problem is that if I run that SQL job while im using the active node ( Two IBM 3950 ) server I get this error

TCP Provider: The semaphore timeout period has expired. [SQLSTATE 08S01] (Error 121)  Communication link failure [SQLSTATE 08S01] (Error 121).  The step failed.

Please note that the SQL job uses the database in the same server and does not communicate to any other servers. the job works fine the if i run it in the passive one with

Please advise

Question by:ITMaster1979
    LVL 10

    Expert Comment

    LVL 42

    Accepted Solution

    The semaphore timeout period has expired
    LVL 1

    Author Comment


     I tried but still the same, any advise
    LVL 42

    Assisted Solution

    can you create any new sql agent job?
    for example with this step
    use yourDB
    select Getdate()

    check what is your sql server \sql agent service  startup accout login  and what the login(s) has  sql server permissions --> can  you login as this account andaccess db? run you sql job code directelly ?

    also check what is your sql server 2005 service pack?

    can you check event viewer\sql error log\sqlagent errors ?

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
    Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

    759 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

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now