Forum Discussion

Nima Mohandesan's avatar
Nima Mohandesan
Copper Contributor
Jan 22, 2020
Solved

Cannot connect to SSIS via SSMS

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
------------------------------

Integration Services
  • 耕志 馮's avatar
    耕志 馮
    Jan 29, 2020

    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

2 Replies

Sort By
  • 耕志 馮's avatar
    耕志 馮
    Brass Contributor
    Jan 29, 2020

    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

Resources