Post reply

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

  • 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.-

  • October 24, 2008 at 2:09 am

    #889059

    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]

  • October 24, 2008 at 2:20 am

    #889062

    Hi,

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

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

  • October 27, 2008 at 1:55 am

    #889851

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

  • October 27, 2008 at 2:18 am

    #889855

    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

  • October 27, 2008 at 2:19 am

    #889857

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

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

  • October 27, 2008 at 2:26 am

    #889859

    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.

  • October 27, 2008 at 3:12 am

    #889870

    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]

  • October 27, 2008 at 2:40 pm

    #890258

    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.

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

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