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
Last activity: May 29, 2019, 12:26 AM