k.arkenau (2/17/2014)
Hello,I got a problem with a user who needs to log on to the integration services.
The user ist is "sysadmin" on the SQL Server and I granted him rights in the DCOM configuration for MSSQL Integration Services (remote and local log-on and remote and local execute and start).
But if the user trys to log-on to the integration services it says "Access denied" and I have no idea why.
Is anyone here who might have a clue what to do?
Many thanks
Yours
k.arkenau
P.S.: I attached screenshots of the settings I made, but they are in german. Perhaps someone can do something with then even though they are not in english.
Firstly, don't grant the user directly to the DCOM permissons in Component services. There is a local Windows group called "Distributed COM Users", use this local group to secure the required permissons and add domain users or groups to the local group.
On the Security tab you need to set permissions in the Launch and Activation Permissions and the Access Permissions. Restart the service after change these permissions
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉