Hi All,
i was ask to grant a developer permissions to use integration services.
he can run the ssis packages and it works fine, but he cant open integration services with sql management studio.
if i am adding him to the local administrators group on the server it works, but he is not a system administrator.
how can i connect to the integratin services without been a local administrator on the server ?
You'll have to add the users domain account to the DCOM users group on the server. The detailed steps are given in this article:-
http://technet.microsoft.com/en-us/library/aa337083.aspx
|||Hi! I just tried this and it did not work even after I restarted the service. Did it work for you? Is there anything special that I need to do other than the instructions from the article?
