Wednesday, March 7, 2012

Restore a Group/Role?

I have a client with an eager IT manager who used Report Manager, saw the
BUILTIN\Administrators group in the roles list and decided to remove it from
the Report Server groups, or I think that is how he did it, he says he is
not sure. Sadly that was the only RS group with Content Manager and
Publisher rights, so no more report publishing/role assignment there.
I looked at the Books Online to see how I can restore/create groups/roles in
RS, but all cases say "use Report Manager and navigate ..." but obviously
that does not apply any more, because Report Manager now does not show the
Site Settings, New Role Assignment, etc.
Must they re-install?
Thanks.There is no need to reinstall. Use account that is windows admin on the box
where Report Server is installed. This account should have sufficient rights
to browse and change security. Admin on the box has these special rights on
Report Server regardless of the Report Server policies.
--
Dmitry Vasilevsky, SQL Server Reporting Services Developer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
---
"Chris Botha" <chris_s_botha@.AT_h.o.t.m.a.i.l.com> wrote in message
news:OQnl$4aaEHA.3988@.tk2msftngp13.phx.gbl...
> I have a client with an eager IT manager who used Report Manager, saw the
> BUILTIN\Administrators group in the roles list and decided to remove it
from
> the Report Server groups, or I think that is how he did it, he says he is
> not sure. Sadly that was the only RS group with Content Manager and
> Publisher rights, so no more report publishing/role assignment there.
> I looked at the Books Online to see how I can restore/create groups/roles
in
> RS, but all cases say "use Report Manager and navigate ..." but obviously
> that does not apply any more, because Report Manager now does not show the
> Site Settings, New Role Assignment, etc.
> Must they re-install?
> Thanks.
>|||Thanks, it sounds good. I will give it a shot tomorrow, they went home
already, and will let you know if it worked.
"Dmitry Vasilevsky [MSFT]" <dmvasi@.microsoft.com> wrote in message
news:e#BflgeaEHA.1356@.TK2MSFTNGP09.phx.gbl...
> There is no need to reinstall. Use account that is windows admin on the
box
> where Report Server is installed. This account should have sufficient
rights
> to browse and change security. Admin on the box has these special rights
on
> Report Server regardless of the Report Server policies.
> --
> Dmitry Vasilevsky, SQL Server Reporting Services Developer
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> --
> ---
> "Chris Botha" <chris_s_botha@.AT_h.o.t.m.a.i.l.com> wrote in message
> news:OQnl$4aaEHA.3988@.tk2msftngp13.phx.gbl...
> > I have a client with an eager IT manager who used Report Manager, saw
the
> > BUILTIN\Administrators group in the roles list and decided to remove it
> from
> > the Report Server groups, or I think that is how he did it, he says he
is
> > not sure. Sadly that was the only RS group with Content Manager and
> > Publisher rights, so no more report publishing/role assignment there.
> > I looked at the Books Online to see how I can restore/create
groups/roles
> in
> > RS, but all cases say "use Report Manager and navigate ..." but
obviously
> > that does not apply any more, because Report Manager now does not show
the
> > Site Settings, New Role Assignment, etc.
> > Must they re-install?
> >
> > Thanks.
> >
> >
>|||Hi Dmitry, in the end it was a re-install and everything is back to normal
now. Thanks in any case.
"Dmitry Vasilevsky [MSFT]" <dmvasi@.microsoft.com> wrote in message
news:e#BflgeaEHA.1356@.TK2MSFTNGP09.phx.gbl...
> There is no need to reinstall. Use account that is windows admin on the
box
> where Report Server is installed. This account should have sufficient
rights
> to browse and change security. Admin on the box has these special rights
on
> Report Server regardless of the Report Server policies.
> --
> Dmitry Vasilevsky, SQL Server Reporting Services Developer
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> --
> ---
> "Chris Botha" <chris_s_botha@.AT_h.o.t.m.a.i.l.com> wrote in message
> news:OQnl$4aaEHA.3988@.tk2msftngp13.phx.gbl...
> > I have a client with an eager IT manager who used Report Manager, saw
the
> > BUILTIN\Administrators group in the roles list and decided to remove it
> from
> > the Report Server groups, or I think that is how he did it, he says he
is
> > not sure. Sadly that was the only RS group with Content Manager and
> > Publisher rights, so no more report publishing/role assignment there.
> > I looked at the Books Online to see how I can restore/create
groups/roles
> in
> > RS, but all cases say "use Report Manager and navigate ..." but
obviously
> > that does not apply any more, because Report Manager now does not show
the
> > Site Settings, New Role Assignment, etc.
> > Must they re-install?
> >
> > Thanks.
> >
> >
>

No comments:

Post a Comment