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.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 All SQL Jobs failing

Author  Topic 

hambo12
Starting Member

7 Posts

Posted - 2013-10-22 : 00:27:53
Hi All, For some reason all of my SQL jobs have been failing on my SQL 2005 server, running Windows 2003 server. The jobs range from DB backups, clean up tasks, index rebuilds, shrink DB's etc.

The only change that has been made is that I have changed the SQL Agent etc Services logon account to a domain account. I am assuming this has caused the issue, however I have tried everything I can find:
- Giving the Login / account appropriate permissions within SQL.
- Making the account a local administrator on the server.

I have previously performed the change in our identical Dev environment, without any issue.

Here is the error message I get for ALL jobs:

Executed as user: [Domain]\svcadmin. Microsoft (R) SQL Server Execute Package Utility  Version 9.00.4035.00 for 32-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    Started:  2:28:13 PM  Progress: 2013-10-22 14:28:58.62     Source: {84A473DD-5949-4B78-A4EA-36377C583661}      Executing query "DECLARE @Guid UNIQUEIDENTIFIER      EXECUTE msdb..sp".: 100% complete  End Progress  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  2:28:13 PM  Finished: 2:28:58 PM  Elapsed:  45.906 seconds.  The package execution failed.  The step failed.


Any ideas? Thanks!

Update: Upon further investigation, it looks as though anything that was modified or saved after changing the SQL Service account has been failing. Any jobs that havent been touched are still running successfully. Weird!

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-10-22 : 07:54:20
whats the protection level used for packages? DOes domain account have access to its sensitive info?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
   

- Advertisement -