sqlmaint.exe failed (SQLSTATE 42000) (Error 22029) The step failed

Question

Post reply

sqlmaint.exe failed (SQLSTATE 42000) (Error 22029) The step failed

IceMan-920581

Mr or Mrs. 500

Points: 586
More actions
October 24, 2008 at 1:56 am

#128086

W2k, SQLserver2k SP4
Simple Db
This occurs in 1-Integrity chcks and 2- Optimizations check, in a Maintenance plan.-
I dont know what happend.
Thanks for your help.-

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

MarkusB SSC-Dedicated Points: 37370 More actions · Answer 1

If you have reporting enabled in your maintenance plan, there should be a logfile with more details about the error.

The error you gave us is just a general error which happens every time a maintennace tasks fails.

[font="Verdana"]Markus Bohse[/font]

Renuka__ Hall of Fame Points: 3656 More actions · Answer 2

Hi,

Right click on Maintenance plan and select Maintenance Plan History. You may get more details there....

[font="Verdana"]Renuka__[/font]

IceMan-920581 Mr or Mrs. 500 Points: 586 More actions · Answer 3

Thanks, here the reports. I have dbo rights, but i dont undertand, this happend 2 weeks ago.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 4

Is it still happening?

What login are the maintenance plans running as? What rights does that login have?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

MarkusB SSC-Dedicated Points: 37370 More actions · Answer 5

Obviously the account under which the maintenance plan is executed has not enough permissions. Check which account is used.

[font="Verdana"]Markus Bohse[/font]

IceMan-920581 Mr or Mrs. 500 Points: 586 More actions · Answer 6

I dont change the user, but this occurs 2 weeks ago and without any change for me. I use sa or other user who have admin rigths. In other DB in "other server" i havent any problem with the same user.

MarkusB SSC-Dedicated Points: 37370 More actions · Answer 7

Without working on the system myself I can't say for sure why the user doesn't have enough permissions anymore.

ISince you use the Local\System account my guess would be that someone removed the Built-In\Admin group and forgot to grant permissions to the service account.

Check if there's a Login NT Authority\SYSTEM and if it has the correct permissions.

[font="Verdana"]Markus Bohse[/font]

IceMan-920581 Mr or Mrs. 500 Points: 586 More actions · Answer 8

Yes Marcus, somebody, "SO administrators delete the user", "i notice FBI". Then in the Connection of the SQL Agent properties, i use the sa user, and finish the problem. Thanks for your help. cya.