Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

maintenance plans in sql server 2005 64-bits Expand / Collapse
Posted Thursday, October 23, 2008 4:47 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Yesterday @ 12:25 PM
Points: 88, Visits: 473
I hope someone can help me sort this issue out: (Maintenanceplan)

we have the following environment:

1: 3 node clustered veritas sql server 2005 64-bits
2: windows 2003 64-bits
3: sql server 2005 SP2 installed including latest hotfixes
4: named instances (within veritas these instances have their own ip-adres for the service groups and the mechanism to failover separate instances e.g servicegroups within veritas.
5: in dns all the named instances have their own dns-entry (for example named instance in sql = test_acc\test_acc customer connects to ) connection to instance is being done with the use of np(named pipe).
6: several instances are running on different machines.
7: sp_helpserver entries are: (name: test_acc\test_acc , network_name:test_acc\test_acc)
8: when i logon to the system i use a domain admin username

the following is happening when creating a maintenance plan with the wizard:

- I logon to the named instance using windows authentication
- I create a maintenance plan with the wizard for a full backup of all the systemdatabases
- Then i let the plan create a different directory for each database on a mounted volume which has been assigned with veritas volume manager (this should not be the problem as i can write to this location)
- When i execute the plan it fails with the following error:

Date 23-10-2008 12:17:08
Log Job History (backup.Subplan_1)

Step ID 1
Server test_ACC\test_ACC
Job Name backup.Subplan_1
Step Name Subplan_1
Duration 00:00:45
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

Executed as user: test_acc\SYSTEM. ...ion 9.00.3042.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 12:17:08 Error: 2008-10-23 12:17:23.97 Code: 0xC00291EC Source: {937B6C65-29A6-4633-9175-3934B83F55AE} 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: 2008-10-23 12:17:23.97 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: 2008-10-23 12:17:38.53 Code: 0xC0024104 Source: Back Up Database (Full) ... The package execution fa... The step failed.

I think this has something to do with the user who is executing the job if i am not mistaken????

I hope that someone can help me with this problem as we are about to go into production phase soon.

For now we can work around this problems using the good all fashioned dos batches calling sql queries for the backup.

Thanks in advance,

Bryan van Ritter
Post #590360
Posted Wednesday, May 23, 2012 2:49 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, July 14, 2014 7:56 AM
Points: 1, Visits: 196
I have the same problem if anyone know resolution please replay
Post #1304785
Posted Wednesday, May 23, 2012 3:08 AM



Group: General Forum Members
Last Login: 2 days ago @ 8:49 AM
Points: 7,030, Visits: 14,716

Does the user test_acc\SYSTEM have access to the server? Is the server configured to log failed logins? If so, what errors are appearing in the errorlog?


Edit: just noticed this is an old thread. malenkof, you're going to need to provide some details if you want anybody to help you. Preferably start a new thread as people are more likely to see it.
Post #1304792
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse