October 9, 2008 at 4:26 am
I have recently changed the accounts that the SQL Server services are running under, which are now AD Accounts, member of local Server Administrators group and a server role of SysAdmin.
However, all my scheduled jobs are now failing with the rror:
Executed as user: COMPUTING\SRV_SQLSERV_TAPOTH03. ... for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 00:00:04 Error: 2008-10-03 00:00:05.94 Code: 0xC00291EC Source: {90BAC4EF-475C-45E3-B256-9BF41B732515} 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: 2008-10-03 00:00:05.94 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: 2008-10-03 00:00:06.43 Code: 0xC0024104 Source: Clean Up History Descrip... The package execution fa... The step failed.
All my other servers are set up the same and cannot see what the issue is, although I would guess it's a permissions one!
Any help?
Regards
Steve
October 10, 2008 at 12:25 am
After changing the password for the SQL Agent, you need to restart it.
Or you may go to the Properties of SQL Server Agent, click Reset Proxy Account under the tab, Job System, to reset its password.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply