SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 All SQL Jobs failing
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

hambo12
Starting Member

Australia
7 Posts

Posted - 10/22/2013 :  00:27:53  Show Profile  Reply with Quote
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!

Edited by - hambo12 on 10/22/2013 01:34:33

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 10/22/2013 :  07:54:20  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000