Cannot connect to SSIS via SSMS

[Nima Mohandesan]

Hi,

I cannot connect to SSIS via SSMS. the error message is below. Please advise. 

TITLE: Connect to Server
------------------------------

Cannot connect to mytestserver.

------------------------------
ADDITIONAL INFORMATION:

Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)

For help, click: https://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&LinkId=20476

------------------------------

Exception from HRESULT: 0xC00160AD (Microsoft.SqlServer.DTSRuntimeWrap)

For help, click: http://go.microsoft.com/fwlink/?LinkId=506689

------------------------------

Exception from HRESULT: 0xC00160AD (Microsoft.SqlServer.DTSRuntimeWrap)

------------------------------
BUTTONS:

OK
------------------------------

[#2 · Accepted solution]

Hi @Nima Mohandesan , 

According to the link that attached after the exception, you need apply SSIS access right because current SQL server won’t grant the SSIS access right by default ( the old version SQL server would grant that by default). Please check out the description below for your reference.

Regards, 

Sten

[#3]

This was the perfect solution. Thank You!  @耕志 馮