Hey, We recently upgraded our SQL server 2000 instance to SQL Server 2008 x86... I've been able to fix all the other issues that arouse from the upgrade, however I'm still having issues with getting our maintenance jobs to work. When they're run I get the following error Executed as user: Domain\Riley. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed. Now I can only presume that this is an issue with account security, however as this was an upgrade, I would of thought that the job would of thrown the same error whilst we were using SQL 2000 instance, but its only occurred since we upgraded to SQL 2008. Cheers

Just an update, I found that these jobs when to the 'Legacy Database maintenance Plans' folder in the Management folder in SQL Management Studio. So I Migrated the job and it created the 'Maintenance Plans' folder and created a new job in the Jobs folder... but when I run it I get an error stating that I need 'Integrated Services" installed. I take it that the 'Integrated Services' is required for all maintenance plans? or have I done something wrong?

Hi Dursh, Yes, Sql Server Integration Services must be and running to run any maintenance plans. Open sql server configuration manager and start SSIS if this service was installed. If not run SQL Server installation media to install SSIS.Sergei

Hi Dursh, Apply SQL Server 2008 SP 1 CU3 or above to this instance. The dependency on SSIS for maintenance plan has been removed in those hot fixes. Pradeep Adiga Blog: sqldbadiaries.com