Forum Discussion
Nima Mohandesan
Jan 22, 2020Copper Contributor
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. -----------------...
- 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
耕志 馮
Jan 29, 2020Brass Contributor
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 MohandesanJan 30, 2020Copper Contributor
This was the perfect solution. Thank You! 耕志 馮