Zahid Ahamed
asked on
Access is denied on Integration Services
Hi Expert,
One of my user requested me to access on the integration services and i gave him access on MSDB database db_ssisadmin but he is getting the error. Error is attached. I suggested him to run SSMS as an administrator but didn't work for him.
Please help!
_error.jpg
One of my user requested me to access on the integration services and i gave him access on MSDB database db_ssisadmin but he is getting the error. Error is attached. I suggested him to run SSMS as an administrator but didn't work for him.
Please help!
_error.jpg
Are your users trying to connect using SQL authentication? In order to connect to integration services, they need to use Windows authentication on the login page in SSMS.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I have resolved this myslef