Unable to connect to SSIS service on machine

Asked By 20 points N/A Posted on -
qa-featured

Hi Expert DBA’s,

When I try to connect to a Microsoft SQL server, I ended up with an error message. In addition, I got this error pop up when I try to connect to SSIS service on machine. The error says the error loading type library dll. I have attached the error image please do check the attachment and explain me to fix the problem. Thanks a lot.

 

Connect to Server

Cannot connect to

Additional information:

      Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)

           Connect to SSIS Service on machine……… failed:

             Error loading type library/DLL.

                   Connect to SSIS Service on machine……….failed:

                   Error loading type library/DLL.

SHARE
Answered By 0 points N/A #168623

Unable to connect to SSIS service on machine

qa-featured

The error shows that the one of the configuration file ( MSDTSSRVR.ini.xml) is corrupted. Just make sure there is the right option selecting TCP/IP for the protocol when logging into SSIS. You must confirm that the service account has access to the SQL Server folder. Reboot your server and make sure the there is access if service account. I hope that will resolve the issue.

Regards,

Related Questions