October 23, 2008 at 4:47 am
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 test_acc.domain.nl ) 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:
Date23-10-2008 12:17:08
LogJob History (backup.Subplan_1)
Step ID1
Servertest_ACC\test_ACC
Job Namebackup.Subplan_1
Step NameSubplan_1
Duration00:00:45
Sql Severity0
Sql Message ID0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted0
Message
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
May 23, 2012 at 2:49 am
I have the same problem if anyone know resolution please replay
May 23, 2012 at 3:08 am
Bryan
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?
John
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.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply