I have a problem, while on vacation the server guys decided to patch up my SQL Server 2005 for me. The SQL Server version is now, 9.00.1406.00 when I went on vacation it was 9.00.1399.06. Two existing maintenance plans fail saying the SSIS subsystem failed to load.
"Step 1 of job 'jed_Reporter_Full_Daily' (0x5343E646E76C364595F49FFA76016266) cannot be run because the SSIS subsystem failed to load. The job has been suspended. "
I can create new maintenance plans, but receive errors when SSMS attempts to create the job for the maintenance plan. The job is created, but it contains no steps. I also cannot open Business Intelligence Studio or Visual Studio. I can see that there were 5 SQL Server hotfixes applied to the server right before the problems started.
GDR 1406 for SQL Server Analysis Services 2005
GDR 1406 for SQL Server Database Services 2005
GDR 1406 for SQL Server Notification Services 2005
GDR 1406 for SQL Server Reporting Services 2005
GDR 1406 for SQL Server Tools and Workstation Components 2005
Can I simply uninstall these and reboot, or will I need to uninstall SQL Server, reinstall, and recover from backup?
Thanks for your time!