cluster server

• dba_neo

  SSCrazy

  Points: 2673

  More actions

  February 19, 2010 at 12:32 pm

  #141618

  Team,

  My Maintenanceplan failed with below error,this was a cluster server

  PRO\sqladmin. ...on 9.00.4035.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 2:10:23 PM Error: 2010-02-19 14:10:38.26 Code: 0xC00291EC Source: {D9C17F9D-B647-474B-891D-F87F244CE2C3} Execute SQL Task Description: Failed to acquire connection "Local server connection". Connection may not be configured correctly or you may not have the right permissions on this connection. End Error Warning: 2010-02-19 14:10:38.27 Code: 0x80019002 Source: OnPreExecute Description: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors. End Warning Error: 2010-02-19 14:10:52.39 Code: 0xC0024104 Source: Check Database Integrity Ta... The package execution fa... The step failed.

• GRE (Gethyn Ellis)

  SSCrazy Eights

  Points: 9602

  More actions

  February 19, 2010 at 4:19 pm

  #1122197

  Has this job ever succeeded?

  Gethyn Elliswww.gethynellis.com