SQL Agent / SSIS Job failing

Everytime i try to run a maintenance job i get the following error thrown, This error happens regardless of the type of job.

I've set the SQL agent to run as the system administrator and i've just installed SQL service pack 3 - however both no joy.

I know it implys to permissions however the user that runs the SQL service agent has both administrator access and backup operator .

Any help or advice would be greatly appreciated

Thanks
P
Executed as user: XXXXXXXXXX. ...5.00 for 32-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    Started:  11:03:04 PM  Error: 2009-05-04 23:03:47.00     Code: 0xC00291EC     
Source: {9447AE0B-CFF3-4827-A728-0D74D11F8086} 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-04 23:03:47.00     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-04 23:04:29.32     Code: 0xC0024104     Source: Back Up Database (Full)   ...  The package execution fa...  The step failed.

Open in new window

paulCardiffAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
tigin44Connect With a Mentor Commented:
the error message describes that you are using a connection to a server that the user under wich  the the job runs has not enough permissions. Check the user has both login rights and database rights correctly.
0
All Courses

From novice to tech pro — start learning today.