Friday, June 08, 2012 5:25 PM
I have a pair of sql 2012 servers with SSIS installed, server 1 configured as a MSX and server 2 configured as TSX. I can create a maintenance plan on the MSX, but the plan does not appear in the TSX. The job does replicate, but fails to run due to missing maintenance plan. I have disabled firewalls, added the TSX SQL server agent service account as a sysadmin on the MSX, recreated the plan, restarted the services, defected and reenlisted the TSX, tried to use another server as a TSX, and so on.
I do find the following errors in the SQL server agent logs:
Date 6/7/2012 6:33:52 PM
Log SQL Server Agent (Current - 6/8/2012 9:51:00 AM)
 An exception (0xe0434f4d) occurred in the Maintenance Plans subsystem
The error occurs every time I add a server to the maintenance plan, and always is seen on the TSX. no errors are seen on the MSX
Monday, June 11, 2012 3:08 AMModerator
Regarding to the error message and your description, please check your data in msdb database. Execute SELECT * FROM msdb.dbo.syssubsystems WHERE subsystem='SSIS' to verify that the files from subsystem_dll and agent_exe columns exist.
For more information, please refer to this KB.
If you'd like to work with maintenance plan(s) that locate on non-default or named (even remote) SQL server instance, see MSDN topic "Configuring the Integration Services Service"in order to modify default settings of Integration Services.
Regards, Amber zhang
- Marked As Answer by amber zhangModerator Monday, June 25, 2012 2:29 AM