TransWikia.com

Unable to Create new Maintenance plan in SSMS 2017

Database Administrators Asked by user9516827 on October 28, 2021

Hi I have reinstalled SQL Server 2016 in my database server last day.
I am able to connect to SQL Instance(SQL-02) using the SSMS 2017 i had earlier in the same server before reinstall.

But when i try to create the maintenance plans,i get the below error.

Exception has been thrown by the target of an invocation. (mscorlib)

Retrieving the COM class factory for component with CLSID {8357986F-76E9-4E0A-A780-FB0541E91ECC} failed due to the following error: 8007007e The specified module could not be found. (Exception from HRESULT: 0x8007007E). (Microsoft.SqlServer.ManagedDTS)

I have done enough research on this and learned from several posts from web that i have to run the below command

REGSVR32.EXE dts.dll

and then disconnect from SSMS and reconnect.
For most of the people ,this solved the issue and for me i still the issue.

I have my sql server in d: drive and i ran the above command as administrator in the below location.

D:Program FilesMicrosoft SQL Server130DTSBinn

I get the message that the .dll is loaded successfuly.
But when i try to create a new maintenance plan i still get the same error.

I didn’t find any other solution for this issue.

Any help is appreciated.

Additional Info:

I have another database sever in the same domain.
I can connect the same instance(SQL-02) in that server’s SSMS 2017 and can create new maintenance plan for the instance.
I am using the same version of SSMS in both servers.

One Answer

I was just searching for this error as it just occurred on my instance as well. Although it wasn't identical, I wanted to put this out there if anyone else runs into the same problem when searching.

  • Server 2019
  • SQL Server Standard 2017 (14.0.2027.2)
  • SSMS 2018 (v.18.5.1)

Went to create a new maintenance plan (the first one on this server and named instance) and received a very similar error out of the gate: Exception has been thrown by the target of an invocation. (mscorlib) Invalid Class String.

I checked all components, etc and my fix was to install SSMS 2017 and use it rather than SSMS 2018. Works just fine now.

Answered by MLB on October 28, 2021

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP