June 20, 2012 at 3:36 am
I get the following error message when trying to run the Mintenance plan. ( As far as I know nothing has changed - I have been away and now checked and it has failed for the last few weeks )
Date20/06/2012 10:34:28
LogJob History (User_DB_MaintenancePlan.Subplan_1)
Step ID0
ServerDO01
Job NameUser_DB_MaintenancePlan.Subplan_1
Step Name(Job outcome)
Duration00:00:00
Sql Severity0
Sql Message ID0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted0
Message
The job failed. Unable to determine if the owner (WORLD\steve.e.clarke) of job User_DB_MaintenancePlan.Subplan_1 has server access (reason: Could not obtain information about Windows NT group/user 'WORLD\steve.e.clarke', error code 0x5. [SQLSTATE 42000] (Error 15404)).
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
June 20, 2012 at 3:48 am
Looks like this is the cause of it !
Message
Non-SysAdmins have been denied permission to run DTS Execution job steps without a proxy account. The step failed.
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply