Solved

SQL Agent / SSIS Job failing

Posted on 2009-05-04
2
286 Views
Last Modified: 2012-05-06
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

0
Comment
Question by:paulCardiff
2 Comments
 
LVL 41

Accepted Solution

by:
ralmada earned 400 total points
ID: 24300484
0
 
LVL 26

Assisted Solution

by:tigin44
tigin44 earned 100 total points
ID: 24306330
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

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question