I would like to be able to administer SQL Server Reporting Services (SSRS)
via the SQL Server Management Studio (SSMS). It appears, in our setup at
least, that the only individuals who are able to use the SSMS are those who
are included in the BUILTIN\Administrators group (admins on the server). Our
setup calls for a separation of roles between those who setup/manage the
servers (setup apps on the servers - local admins on the server) and those
who will administer the application after it is installed. I am setup with
the System Administrator Role and with Content Manager in the HOME folder. I
am not able to connect to the SSRS instance via SSMS, where the local admins
(BUILTIN\Administrators) are able to manage SSRS via the SSMS. Is there a
way for the non local admins to use SSMS to administer SSRS?What is it that you are trying to do. Most of the type of admin type work to
do with RS is done via Report Manager (the protal that ships with RS).
Subscriptions, assigning roles, etc. What are you trying to do that you need
to use SSMS to do?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"LTC" <LTC@.discussions.microsoft.com> wrote in message
news:A4AEDC9B-D588-4DDB-9729-F1A309EDCA39@.microsoft.com...
>I would like to be able to administer SQL Server Reporting Services (SSRS)
> via the SQL Server Management Studio (SSMS). It appears, in our setup at
> least, that the only individuals who are able to use the SSMS are those
> who
> are included in the BUILTIN\Administrators group (admins on the server).
> Our
> setup calls for a separation of roles between those who setup/manage the
> servers (setup apps on the servers - local admins on the server) and those
> who will administer the application after it is installed. I am setup
> with
> the System Administrator Role and with Content Manager in the HOME folder.
> I
> am not able to connect to the SSRS instance via SSMS, where the local
> admins
> (BUILTIN\Administrators) are able to manage SSRS via the SSMS. Is there a
> way for the non local admins to use SSMS to administer SSRS?|||I have been using Report Manager portal for RS, however I use the SSMS to
administer SS DBMS and SSAS. It would be more convenient to work all within
one tool.
"Bruce L-C [MVP]" wrote:
> What is it that you are trying to do. Most of the type of admin type work to
> do with RS is done via Report Manager (the protal that ships with RS).
> Subscriptions, assigning roles, etc. What are you trying to do that you need
> to use SSMS to do?
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "LTC" <LTC@.discussions.microsoft.com> wrote in message
> news:A4AEDC9B-D588-4DDB-9729-F1A309EDCA39@.microsoft.com...
> >I would like to be able to administer SQL Server Reporting Services (SSRS)
> > via the SQL Server Management Studio (SSMS). It appears, in our setup at
> > least, that the only individuals who are able to use the SSMS are those
> > who
> > are included in the BUILTIN\Administrators group (admins on the server).
> > Our
> > setup calls for a separation of roles between those who setup/manage the
> > servers (setup apps on the servers - local admins on the server) and those
> > who will administer the application after it is installed. I am setup
> > with
> > the System Administrator Role and with Content Manager in the HOME folder.
> > I
> > am not able to connect to the SSRS instance via SSMS, where the local
> > admins
> > (BUILTIN\Administrators) are able to manage SSRS via the SSMS. Is there a
> > way for the non local admins to use SSMS to administer SSRS?
>
>
No comments:
Post a Comment