Sample Header Ad - 728x90

Multi server administration - Failed to import Maintenance Plan to named instance

1 vote
1 answer
198 views
I have a multi server administration environment and several maintenance plans deployed already. My MSX server is SQL2014. The problem i'm having is deploying maintenance plans to a 2008R2 named instance which is running alongside a default 2014 instance (which is working with MSX MPs already). I'm getting this error: Failed to import Maintenance Plan 'MSA backup' from MSX: Microsoft.SqlServer.Dts.Runtime.DtsRuntimeException: Error loading from XML. No further detailed error information can be specified for this problem because no Events object was passed where detailed error information can be stored. ---> System.Runtime.InteropServices.COMException (0xC0011008): Error loading from XML. No further detailed error information can be specified for this problem because no Events object was passed where detailed error information can be stored. I added the account under which the agent service is running on the MSX to the sysadmin role on the named instance. I know it's trying to import to SSIS but there can only be one SSIS instance on a machine and that is the default, 2014 instance. Locally created MPs run without problems. I can provide more info if needed. I have googled without luck so far, but will continue. TY.
Asked by JohnnyP (35 rep)
May 28, 2019, 12:51 PM
Last activity: May 29, 2019, 12:26 AM