Integration Services: Access is denied for developers

  • We have a new installation of Sql 2008 Integration Services on a windows 2003 server environment. When a developer wants to connect to this service he gets a message 'Connect to Analysis services failed' 'Access is Denied'. My Id is part of Admin group on the machine, and I have no issues connecting. I tried to follow the article that Microsoft published (http://msdn.microsoft.com/en-us/library/aa337083.aspx), with no luck. Any one having similar problems. Thanks for all your help.

  • The following has been done to fix the problem.

    Added the failing account/group to the Distributed COM Users Local Group on the SSIS Server

    Computer Management > System Tools > Local Users and Groups > Distributed COM users

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply