0

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 Files\Microsoft SQL Server\130\DTS\Binn

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.

  • Does the issue occur with the latest SSMS release? – LowlyDBA Jul 3 at 15:08
  • @LowlyDBA. I am not using latest SSMS ,i am using an older version of SSMS 2017 which i installed last year.Only change i did is reinstall SQL Server 2016 in the server. – user9516827 Jul 3 at 15:13
  • 1
    I understand that, I am suggesting you try using a more recent version which may have this issue fixed. – LowlyDBA Jul 3 at 15:27
  • Okay i will try that. – user9516827 Jul 3 at 15:31
  • @LowlyDBA I added some additonal info.Pls check.Do you still think it is with the SSMS verison? – user9516827 Jul 3 at 15:36

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.