SQL Server 2000 sqlmaint.exe maintenance plan execution error
Posted on 2008-10-09
I am experiencing a problem with my maintenance plans running under SQL Server 2000 running on Windows 2000. I suspect that the error (below) is occurring due to permissions problems with the user executing the maintenance plan. What permissions does the executing user need to hold and where do I verify this and change the details if necessary?
sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The Step failed.
Executed as user: NT Authority\SYSTEM. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The Step failed.