Showing posts with label migration. Show all posts
Showing posts with label migration. Show all posts

Friday, March 30, 2012

rsInvalidPolicyDefinition - migration to another domain .....

Hi friends,

We have a problem with our RS2005 after migration into another domain.

The problem is that we have got duplicate access rights for the same AD usergroup.
When trying to remove or add a new AD group we get the error msg - "... 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)"

Books online gives no answers and neither does other serach engines .....

Anyone having a hint or solution .......

We have the same problem. Cannot remove some roles. I'm worried about if we need to make changes later, will we have to destroy the entire folder structure & re-create it in order to get rid of these roles/permissions?

rsInvalidPolicyDefinition - migration to another domain .....

Hi friends,

We have a problem with our RS2005 after migration into another domain.

The problem is that we have got duplicate access rights for the same AD usergroup.
When trying to remove or add a new AD group we get the error msg - "... 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)"

Books online gives no answers and neither does other serach engines .....

Anyone having a hint or solution .......

We have the same problem. Cannot remove some roles. I'm worried about if we need to make changes later, will we have to destroy the entire folder structure & re-create it in order to get rid of these roles/permissions?sql

rsInvalidPolicyDefinition

Greetings,
I am running SQL Server 2005 Reporting Services on a SQL Server 2000
(sp4) database and am running into an issue after a domain migration
that is preventing me from modifying any of the security settings on
the report server.
When attempting to Delete or Modify security settings on a folder i
receive the following message:
The "<All the users w/ access to the folder>" 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) Get Online Help.
Has anyone seen this before or have suggestions as to where to start
troubleshooting it?
Thanks in advance,
Ben SullinsI've found a work around by clicking 'Revert to Parent secruty' on
these folders then going back in and modifying them. This only happens
on folders where the same user/group is listed 2x. Not sure how that
happened but I'm guessing it had to do w/ our domain migration...
sullins602 wrote:
> Greetings,
> I am running SQL Server 2005 Reporting Services on a SQL Server 2000
> (sp4) database and am running into an issue after a domain migration
> that is preventing me from modifying any of the security settings on
> the report server.
> When attempting to Delete or Modify security settings on a folder i
> receive the following message:
> The "<All the users w/ access to the folder>" 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) Get Online Help.
> Has anyone seen this before or have suggestions as to where to start
> troubleshooting it?
> Thanks in advance,
> Ben Sullins

Wednesday, March 7, 2012

RS Migration to new server

My team is moving its development to London. A Reporting Services
server has been configured in London, but aside from simply importing
existing RDLs, what is the best way to migrate existing subscriptions,
snapshots, etc. to the new server from the old? Is this simply a copy
of certain tables in the Reporting Services database?
At a 10,000-ft. level, how can this be accomplished? A simple link to a
how-to will suffice, I just had trouble finding one.
Thanks!
MikeDid you ever receive help on this. We're going through the same thing, and I
have two servers to migrate.
--
Thanks,
CGW
"Bassist695" wrote:
> My team is moving its development to London. A Reporting Services
> server has been configured in London, but aside from simply importing
> existing RDLs, what is the best way to migrate existing subscriptions,
> snapshots, etc. to the new server from the old? Is this simply a copy
> of certain tables in the Reporting Services database?
> At a 10,000-ft. level, how can this be accomplished? A simple link to a
> how-to will suffice, I just had trouble finding one.
> Thanks!
> Mike
>|||This link should help if you are moving to the SAME version of reporting
services..
http://support.microsoft.com/default.aspx?scid=kb;en-us;842425
If you are using a different version, then you're in the same boat as I am.
If you get any info on migrating to newer version, please let me know.
Hope this helps
"CGW" wrote:
> Did you ever receive help on this. We're going through the same thing, and I
> have two servers to migrate.
> --
> Thanks,
> CGW
>
> "Bassist695" wrote:
> > My team is moving its development to London. A Reporting Services
> > server has been configured in London, but aside from simply importing
> > existing RDLs, what is the best way to migrate existing subscriptions,
> > snapshots, etc. to the new server from the old? Is this simply a copy
> > of certain tables in the Reporting Services database?
> >
> > At a 10,000-ft. level, how can this be accomplished? A simple link to a
> > how-to will suffice, I just had trouble finding one.
> >
> > Thanks!
> > Mike
> >
> >|||Excellent!
--
Thanks,
CGW
"J Selburg" wrote:
> This link should help if you are moving to the SAME version of reporting
> services..
> http://support.microsoft.com/default.aspx?scid=kb;en-us;842425
> If you are using a different version, then you're in the same boat as I am.
> If you get any info on migrating to newer version, please let me know.
> Hope this helps
> "CGW" wrote:
> > Did you ever receive help on this. We're going through the same thing, and I
> > have two servers to migrate.
> > --
> > Thanks,
> >
> > CGW
> >
> >
> > "Bassist695" wrote:
> >
> > > My team is moving its development to London. A Reporting Services
> > > server has been configured in London, but aside from simply importing
> > > existing RDLs, what is the best way to migrate existing subscriptions,
> > > snapshots, etc. to the new server from the old? Is this simply a copy
> > > of certain tables in the Reporting Services database?
> > >
> > > At a 10,000-ft. level, how can this be accomplished? A simple link to a
> > > how-to will suffice, I just had trouble finding one.
> > >
> > > Thanks!
> > > Mike
> > >
> > >