<div>
<a href="http://social.msdn.microsoft.com/Forums/en-US/sqldataaccess/thread/d99b4d8e-feeb-43cb-80af-3d4826340a2c" rel="ugc nofollow">http://social.msdn.microsoft.com/Forums/en-US/sqldataaccess/thread/d99b4d8e-feeb-43cb-80af-3d4826340a2c</a><br />
<br />
<a href="http://support.microsoft.com/kb/325487/en-us" rel="ugc nofollow">http://support.microsoft.com/kb/325487/en-us</a><br />
<br />
Thanks<br />

</div>


http://social.msdn.microsoft.com/Forums/en-US/sqldataaccess/thread/d99b4d8e-feeb-43cb-80af-3d4826340a2c [http://social.msdn.microsoft.com/Forums/en-US/sqldataaccess/thread/d99b4d8e-feeb-43cb-80af-3d4826340a2c]

http://support.microsoft.com/kb/325487/en-us [http://support.microsoft.com/kb/325487/en-us]

Thanks


<div>
Hi<br />
<br />
&nbsp;I tried but still the same, any advise
</div>


Hi

 I tried but still the same, any advise

<div>
<div class="content wysiwyg-content">
Hi All,<br />
<br />
&nbsp; My setup:<br />
<br />
SQL 2005 Active/passive<br />
<br />
The active node is two IBM 3950 Connected to each others ( Cascading) and the passive is a single server IBM 3920.<br />
<br />
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<br />
<br />
TCP Provider: The semaphore timeout period has expired. [SQLSTATE 08S01] (Error 121) &nbsp;Communication link failure [SQLSTATE 08S01] (Error 121). &nbsp;The step failed.<br />
<br />
<br />
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 <br />
<br />
Please advise<br />
<br />
Thanks
</div>
</div>


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

Thanks

SQL 2005 cluster Error

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.