Unable to connect to SSIS service on machine

Asked By Edward S Banuelos 20 points N/A Posted on - 05/25/2014

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.

• Status: Open
• Question Views: 840
• Answer Count: 1
• Vote Up 1 Vote Down

• Answer Accepted: No
• Question Category: MS SQL Server

Answered By Bailey Jonathan 0 points N/A #168623

Unable to connect to SSIS service on machine

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,

About Bailey Jonathan

Questions
2

Answers
70

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 06/14/2014
• Question Category: MS SQL Server