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 |
|
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 MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
|
|
|
All SQL Jobs failing