SQL Server Performance

SQL Plans failing in cluster set up

Discussion in 'SQL Server 2005 Clustering' started by techbabu303, May 27, 2008.

  1. techbabu303 New Member

    <p>&nbsp;Hi All,</p><p>One of my collegus is working for new client&nbsp; and is facing issues when trying to modify the plans,</p><p>Environment:</p><p>Windows 2003 Sp1</p><p>SQL server 2005 SP 2 cluster set up</p><p>The shared drive and qurom drive are accessible from the passive node but not from the active node. The active node in cluster administrator is lsited having access to the drives.&nbsp;</p><p>Issue:</p><p>The back up clean up job fails and we are also not able to view or modify plans.We are able to view and modify the plans from the passive server and also execute clean up plan from the passive one<br></p><p>Error message :</p><p><img src="file:///C:/DOCUME%7E1/SNAGAR%7E1/LOCALS%7E1/Temp/moz-screenshot-3.jpg" alt="">Exception from HRESULT:..... (Microsoft.sqlserver.DTSruntimewrap)</p><p>&nbsp;</p><p>Any ideas how to edit or view the plans in active server, for now I asked her to check if the sa user can do it on active node.&nbsp;&nbsp;</p><p>&nbsp;</p><p>Please advice.</p><p>Thx</p><p>Sat&nbsp;</p><p>&nbsp;</p><p>&nbsp;</p><p>&nbsp;</p><p><br>&nbsp;</p><p>&nbsp;</p><p>&nbsp;</p><p>&nbsp;</p><p>&nbsp;</p><p>&nbsp;</p>
  2. satya Moderator

    SOunds like the cluster dependancy for Quorum is not set or corrupted on active node, dig deeper on cluster.log file.
  3. techbabu303 New Member

    Will check and update.

Share This Page