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

Integration Services

耕志馮
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

耕志馮

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

Nima Mohandesan

Copper Contributor

Jan 30, 2020

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

Forum Discussion

Cannot connect to SSIS via SSMS

Resources