I'm guessing (without seeing the code that is running) that it is not a
permissions issue.

It's that you have on the Integrity tab 'attempt to repair any minor
problems' checked. If you look at the actual log, you'd see that SQL
Server could not put the DB in Single User mode and thus that step
failed.

Try un-checking that box and see what happens.

Let us know,

Thanks,
Wes


Wes Wilson
REGISTRAT, Inc.
Sr. Systems Administrator / Data Base Administrator


-----Original Message-----
From: gebo
[mailto:mssqldba-ezmlmshield-x64458630.[Email address protected]
Sent: Friday, June 30, 2006 2:37 AM
To: LazyDBA Discussion
Subject: [SQLSTATE 42000] (Error 22029)

Hi all,
I still get the same error, i given the nt authority rights but still
the jobs cannot run, the startup account for sql agents is syem acount,
while for sql server is 'startup' domain acount.
below is the error description.

please help me.

"Executed as user: NT AUTHORITY\SYSTEM. sqlmaint.exe failed. [SQLSTATE
42000] (Error 22029). The step failed."


BSC Computer Science, MBA
System Engineer
MCP


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Website :
http://www.LazyDBA.com To unsubscribe:
http://www.lazydba.com/unsubscribe.html


MS Sql Server LazyDBA home page