SOLVED

Cannot connect to SSIS via SSMS

%3CLINGO-SUB%20id%3D%22lingo-sub-1123243%22%20slang%3D%22en-US%22%3ECannot%20connect%20to%20SSIS%20via%20SSMS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1123243%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20cannot%20connect%20to%20SSIS%20via%20SSMS.%20the%20error%20message%20is%20below.%20Please%20advise.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETITLE%3A%20Connect%20to%20Server%3CBR%20%2F%3E------------------------------%3C%2FP%3E%3CP%3ECannot%20connect%20to%20mytestserver.%3C%2FP%3E%3CP%3E------------------------------%3CBR%20%2F%3EADDITIONAL%20INFORMATION%3A%3C%2FP%3E%3CP%3EFailed%20to%20retrieve%20data%20for%20this%20request.%20(Microsoft.SqlServer.Management.Sdk.Sfc)%3C%2FP%3E%3CP%3EFor%20help%2C%20click%3A%20%3CA%20href%3D%22https%3A%2F%2Fgo.microsoft.com%2Ffwlink%3FProdName%3DMicrosoft%2520SQL%2520Server%26amp%3BLinkId%3D20476%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fgo.microsoft.com%2Ffwlink%3FProdName%3DMicrosoft%2520SQL%2520Server%26amp%3BLinkId%3D20476%3C%2FA%3E%3C%2FP%3E%3CP%3E------------------------------%3C%2FP%3E%3CP%3EException%20from%20HRESULT%3A%200xC00160AD%20(Microsoft.SqlServer.DTSRuntimeWrap)%3C%2FP%3E%3CP%3EFor%20help%2C%20click%3A%20%3CA%20href%3D%22http%3A%2F%2Fgo.microsoft.com%2Ffwlink%2F%3FLinkId%3D506689%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttp%3A%2F%2Fgo.microsoft.com%2Ffwlink%2F%3FLinkId%3D506689%3C%2FA%3E%3C%2FP%3E%3CP%3E------------------------------%3C%2FP%3E%3CP%3EException%20from%20HRESULT%3A%200xC00160AD%20(Microsoft.SqlServer.DTSRuntimeWrap)%3C%2FP%3E%3CP%3E------------------------------%3CBR%20%2F%3EBUTTONS%3A%3C%2FP%3E%3CP%3EOK%3CBR%20%2F%3E------------------------------%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1123243%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EIntegration%20Services%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1138476%22%20slang%3D%22en-US%22%3ERe%3A%20Cannot%20connect%20to%20SSIS%20via%20SSMS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1138476%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F70866%22%20target%3D%22_blank%22%3E%40Nima%20Mohandesan%3C%2FA%3E%26nbsp%3B%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAccording%20to%20the%20link%20that%20attached%20after%20the%20exception%2C%20you%20need%20apply%20SSIS%20access%20right%20because%20current%20SQL%20server%20won%E2%80%99t%20grant%20the%20SSIS%20access%20right%20by%20default%20(%20the%20old%20version%20SQL%20server%20would%20grant%20that%20by%20default).%20Please%20check%20out%20the%20description%20below%20for%20your%20reference.%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20877px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F167974iF7BAAF0A40C822C7%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22997740F9-ECFF-4A17-A38D-90CAA1570FBB.jpeg%22%20title%3D%22997740F9-ECFF-4A17-A38D-90CAA1570FBB.jpeg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3ERegards%2C%26nbsp%3B%3C%2FP%3E%3CP%3ESten%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1141671%22%20slang%3D%22en-US%22%3ERe%3A%20Cannot%20connect%20to%20SSIS%20via%20SSMS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1141671%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20was%20the%20perfect%20solution.%20Thank%20You!%26nbsp%3B%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F80338%22%20target%3D%22_blank%22%3E%40%E8%80%95%E5%BF%97%20%E9%A6%AE%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
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!  @耕志 馮