SOLVED

Cannot connect to SSIS via SSMS

Contributor

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 Replies
best response confirmed by Nima Mohandesan (Contributor)
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.
997740F9-ECFF-4A17-A38D-90CAA1570FBB.jpeg

Regards, 

Sten

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