September 7, 2009 at 5:53 am
when i am executing optimiser jonb job failed due to
[SQLSTATE 42000] (Error 22029)
Executed as user: NT AUTHORITY\SYSTEM. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.
how to resolve this
replies are highly valuable
September 7, 2009 at 6:21 am
when i checked in the history i didnt fnd any reason step 2 failed as update statistics
can any one explain how to resolve this ?
September 7, 2009 at 6:41 am
Hi,
This looks like it could be a permissions problem. Possibly.
When you say 'optimization job' what exactly do you mean, do you mean a step in a maintenance plan such as a statistic update?
Have you tried executing the SQL under an admin login, if it works with that then it would suggest further that it's a permissions issue.
September 7, 2009 at 7:20 am
yes one of the step as update statistics failed due to
[SQLSTATE 42000] (Error 22029)
Message
Executed as user: NT AUTHORITY\SYSTEM. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.
September 7, 2009 at 7:25 am
ok, have you tried executing viewing the T-SQL for the step and then executing as an admin users.
Beware though if you have many tables as scripting it could take some time to script it.
I'm fairly confident that it's a permissions issue, may be worth checking that out.
September 7, 2009 at 7:30 am
MrT-SQL (9/7/2009)
Hi,This looks like it could be a permissions problem. Possibly.
When you say 'optimization job' what exactly do you mean, do you mean a step in a maintenance plan such as a statistic update?
Have you tried executing the SQL under an admin login, if it works with that then it would suggest further that it's a permissions issue.
If it is a maintenance plan, look at the maintenance plan history and post what is says against the failure
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
September 8, 2009 at 11:35 am
Is this SQL 2005? You have to allow XP_Cmdshell with the Surface Area Configuration tool.
http://msdn.microsoft.com/en-us/library/ms173748%28SQL.90%29.aspx
September 10, 2009 at 9:14 am
Some things to check:
Is your SQL Server running under a 'named' account or LocalSystem ?
Is NT Authority\System in the sysadmin role ?
Have you removed BuiltIn\Administrators ?
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply