I am having the exact same problem. We have a database maintenance plan with 1 task in it named "Check Database Integrity Task". Task details: Connection = Local server connection, Database(s): Specific databases (I only have master checked), include indexes is unchecked. When I right click on the plan and click Execute, the plan fails. If I right click on the plan and click View History, it displays the information: Server FH_SQL\Veritas, Task detail: Check Database integrity on Local server connection Databases: master, Error number: 0, Error message: Alter failed for Server 'FH_SQL\\Veritas'. I do not know why this message displays the double '\\' for the named instance, and this may be part of the problem with the job failing. I have also checked "Reporting & logging option" and here are the details:
NEW COMPONENT OUTPUT
Microsoft(R) Server Maintenance Utility (Unicode) Version 9.0.3042
Report was generated on "FH_SQL\Veritas".
Maintenance Plan: MaintenancePlan Integrity Check Test
Status: Warning: One or more tasks failed..
Check Database Integrity (FH_SQL\Veritas)
Check Database integrity on Local server connection
Task start: 2008-07-28T10:00:54.
Task end: 2008-07-28T10:00:54.
FailedSad0) Alter failed for Server 'FH_SQL\\Veritas'.
Please let me know what you think and thank you!
Also, The last thing I did on the server was to move tempdb to another drive and I also changed the accounts that SQL server runs under. The SQL server and SQL server agent were localsystem and they are now different domain accounts.