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.
| Author |
Topic |
|
NeilG
Aged Yak Warrior
530 Posts |
 Posted - 2009-05-22 : 06:13:25
|
| Hi Guys, Hope that someone has some ideas with this one, Ive create a new Maintenance plan to back up some new databases that have been created. However when running the plan i now receive this error.Executed as user: DomainA\emsqlag. ...3042.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 10:31:58 Error: 2009-05-22 10:32:01.47 Code: 0xC00291EC Source: {67EF2D6D-B718-4896-AE74-28D3C6F62D93} 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: 2009-05-22 10:32:01.47 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: 2009-05-22 10:32:01.53 Code: 0xC0024104 Source: Backup of SRM Databases ... The package execution fa... The step failed.However i know that this login has the correct security permissions as its runs numorous job which haven't been created as a Maintenance Plan.Is there anything that im missing with creating this, also what is confusing me is the fact that i've created these plans before and they've work okAny help is much appreciated Cheers |
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2009-05-22 : 06:27:44
|
| Anyoe ever come across something like this |
 |
|
|
svicky9
Posting Yak Master
232 Posts |
Posted - 2009-05-26 : 10:57:07
|
| a. Which server are you running(Windows 2003 or Windows 2008)b. What is your Sql server Edition and service pack ?c. Any errors on the event logs..about security.My assumption is you may not have server level permissions to the system tasks..Check what permissions the login has (server role)http://www.sqlserver007.com |
|
|
|
chriztoph
Posting Yak Master
184 Posts |
Posted - 2009-05-27 : 04:40:47
|
| try to create a new folder then your change the path of your backup file path to the newly created folder then run your MaintenancePlan.. |
|
|
|
|
|
|
Problem running Maintenance plan