Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 maintenance plan error

Author  Topic 

DBA007
Posting Yak Master

145 Posts

Posted - 2010-06-21 : 17:08:48
Team,
my maintenance plan failed with error
9.00.4035.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 12:00:00 AM Progress: 2010-06-21 00:00:02.94 Source: {EC1BEFC4-DBFE-42F1-B467-EDDC9C9554AE} Executing query "DECLARE @Guid UNIQUEIDENTIFIER EXECUTE msdb..sp".: 100% complete End Progress Error: 2010-06-21 00:00:34.74 Code: 0xC0024104 Source: Check Database Integrity Task Description: The Execute method on the task returned error code 0x80131904 (A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)). The Execute method must succeed, and indicate the result using an "out" parameter. End Error Error: 2010-06-2... The package execution fa... The step failed.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-06-21 : 17:14:57
The plan wasn't able to connect to the database server. You'll need to figure out why. Check this out for help: http://weblogs.sqlteam.com/tarad/archive/2008/05/23/60609.aspx

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -