Hi, I granted active directory group access on msdb database roles for integration services, added login to dcom but still user belonging to that group cannot login remotly from their computer. There is message login failed. I am stuck up, please help. Thanks

How do they login (using what) and for what purpose?Arthur My Blog

Hi , "but still user belonging to that group cannot login remotly " that means it's an AD issue, maybe he is not listed in that group, since he's the only one who can't login. or maybe he has 2 accounts or belongs to another group that overrid the first group's permission. MCITP - BI 2008 http://asqlb.blogspot.com/

They are trying to connect using SSMS. They are developer and need access to integrated services and SSIS packages. They have only one active directory group. Users are part of this group. When they try to login through sql server management studio, access denied message comes. They can login on database engine with same account. only problem is with ssis.

They are trying to connect using SSMS. They are developer and need access to integrated services and SSIS packages. They have only one active directory group. Users are part of this group. When they try to login through sql server management studio, access denied message comes. They can login on database engine with same account. only problem is with ssis. In your question you said 'USER' not 'USERS' so I thought it's one of them who can't login! anyway, see that link..it will help you http://msdn.microsoft.com/en-us/library/ms141053(v=SQL.90).aspx also http://www.sqlservercentral.com/blogs/robert_davis/archive/2008/08/13/How-do-I-grant-access-permissions-for-SSIS-to-users.aspx please post back your experience.MCITP - BI 2008 http://asqlb.blogspot.com/