Integrity Check From Maintenance Plan Fails - Error 22029

Hello,
I created a Maintenance plan and the only thing I have it do is perform an
Integrity Check on the database. It's been running successfully for 2 years.
I recently Added Replication to this server, having the data from this
server replicated onto a backup server. During that setup, I had to let
SQLServer Agent run as a different user than the system Administrator for
some reason. So I changed it to run as a different Windows User that has
Administrator privileges.
The command for the check is:
EXECUTE master.dbo.xp_sqlmaint N'-PlanID
D2A9902D-1F5F-4FCB-8819-62609F141FD5 -WriteHistory -CkDBRepair '
Now the Integrity Check won't run.
The user is set as a user on the Server with Admin privileges with Access to
the database in question.
Since I'm trying to let it do the minor repair, could it be that Agent
running as a different user doesn't get the exclusive access it needs?
Thanks for any help.
JohnSpecify a report file for the job and check for the specific errors in the report file.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"John Manion" <JohnManion@.discussions.microsoft.com> wrote in message
news:E77351D7-DA36-43B4-9C61-C31FCF1EBA99@.microsoft.com...
> Hello,
> I created a Maintenance plan and the only thing I have it do is perform an
> Integrity Check on the database. It's been running successfully for 2 years.
> I recently Added Replication to this server, having the data from this
> server replicated onto a backup server. During that setup, I had to let
> SQLServer Agent run as a different user than the system Administrator for
> some reason. So I changed it to run as a different Windows User that has
> Administrator privileges.
> The command for the check is:
> EXECUTE master.dbo.xp_sqlmaint N'-PlanID
> D2A9902D-1F5F-4FCB-8819-62609F141FD5 -WriteHistory -CkDBRepair '
> Now the Integrity Check won't run.
> The user is set as a user on the Server with Admin privileges with Access to
> the database in question.
> Since I'm trying to let it do the minor repair, could it be that Agent
> running as a different user doesn't get the exclusive access it needs?
> Thanks for any help.
> John