Prev: Report that would list folder security setting
Next: SSRS 2008 Condition Column Visibility Whitspace Issue
From: greenmtnsun on 27 Oct 2009 19:27
Without giving someone membership into the "BUILTIN\Administrators" group,
how would one enable a user to be able to access SSRS through SSMS?

SSMS >> Connect >> Reporting Services >> {Server Name}

I'm currently getting the error below:
TITLE: Connect to Server
------------------------------

Cannot connect to {servername}. (removed the server name)

------------------------------
ADDITIONAL INFORMATION:

A connection to the computer cannot be established.
(Microsoft.SqlServer.Management.UI.RSClient)

------------------------------

Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))
(mscorlib)

------------------------------
BUTTONS:

OK
------------------------------

From: Mark Fitzgerald on 28 Oct 2009 09:57
Using a login that currently has systems administration rights on the SSRS:

- access the Report Server (http://machinename/reports).
- choose the option for site setting
- under security add a new role assignment for that user / group i.e.
domainname\ReportAdmin and allocate the System Administration system role
- save

Members of the domainname\ReportAdmin group (or any other named group you
want or individuals) will now be able to access the SSRS within SSMS.

Please be aware that the use of SSMS to manage SSRS has changed
substantially between 2005 and 2008. The reports are no longer available
within the SSMS RS management section leaving jobs, security and shared
schedules (i.e. forcing the use of the report manager). The permissions do
not change for the report manager and SSMS access.

Fitz


"greenmtnsun" <greenmtnsun(a)discussions.microsoft.com> wrote in message
news:6C85B1B7-13BA-4671-A3BD-B01B51E70249(a)microsoft.com...
> Without giving someone membership into the "BUILTIN\Administrators" group,
> how would one enable a user to be able to access SSRS through SSMS?
>
> SSMS >> Connect >> Reporting Services >> {Server Name}
>
> I'm currently getting the error below:
> TITLE: Connect to Server
> ------------------------------
>
> Cannot connect to {servername}. (removed the server name)
>
> ------------------------------
> ADDITIONAL INFORMATION:
>
> A connection to the computer cannot be established.
> (Microsoft.SqlServer.Management.UI.RSClient)
>
> ------------------------------
>
> Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))
> (mscorlib)
>
> ------------------------------
> BUTTONS:
>
> OK
> ------------------------------
>
 | 
Pages: 1
Prev: Report that would list folder security setting
Next: SSRS 2008 Condition Column Visibility Whitspace Issue