Post reply

SSRS 2005 assigning rights to the user giving the error...

  • April 27, 2011 at 10:19 am

    #236391

    Hi,

    We changed our domain name and now when I deploy new reports and trying to assign rights to that report using Security->Edit Item Security - it's giving the below error:

    " role assignment is not valid. The role assignment is either empty or it specifies a user or group name that is already used in an existing role assignment for the current item. (rsInvalidPolicyDefinition)

    Thanks in Advance.

    Thanks.

    Gunjan.

  • April 27, 2011 at 1:33 pm

    #1316857

    I think the problem has to do with duplicate groups or users. What happened in my case is we had a gradual migration from one domain to the other. We set up groups in the new domain and kept the old domain. When the server was migrated from the old domain, groups were re-created in the new domain and created duplicates. This is what is generating the error in Reporting Services.

    The fix - 1. Backup the reporting services database just in case!!!

    2. Document what the existing permissions

    3. Try and delete all the duplicates at one time.

    What happened in my case is that everything but the builtin\administrators was removed. Rather than deleting just the duplicates it deleted all the groups.

    4. Add the groups back from the documentation in step 2

    Try deleting it from the Enterprise Manager.

    Thanks.

    Gunjan.

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

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