Newsletters Archive - All

If you would like to know more about the iDevelopment.info Newsletter, please email me.


  Permissions Error Accessing Reporting Services - (SQL Server 2008 R2) — (14-March-2011)

After installing a Reporting Services instance and setting up a native mode 
default configuration, the next step would be to verify that the Report Server 
and Report Manager is functioning correctly. The virtual directories to use for 
the Report Server and Report Manager can be accessed from a Web browser as 
follows:

  * SQL Server Default Instance

    For a default SQL Server instance, use http://ServerName/DirectoryName 
    where ServerName is the host name or DNS name for the machine and 
    DirectoryName is the name of the virtual directory for either the Report 
    Server (ReportServer) or Report Manager (Reports). For example:

    http://vmwindows1/ReportServer
    http://vmwindows1/Reports

  * SQL Server Named Instance

    For a named SQL Server instance, use
    http://ServerName/DirectoryName$InstanceName
    where ServerName is the host name or DNS name for the machine, 
    DirectoryName is the name of the virtual directory for either the Report 
    Server (ReportServer) or Report Manager (Reports), and InstanceName is the 
    SQL Server instance name. For example:

    http://vmwindows1/ReportServer$WebApps01
    http://vmwindows1/Reports$WebApps01

After providing valid credentials, you will most likely receive the following 
error message when trying to access either the Report Manager or Report Server 
for the first time:

    User '\' does not have required permissions.
    Verify that sufficient permissions have been granted and Windows
    User Account Control (UAC) restrictions have been addressed.

The following article provides a solution to this common permissions error you 
may receive while attempting to authenticate to the Report Server or Report 
Manager.

Permissions Error Accessing Reporting Services - (SQL Server 2008 R2)

----------------------------
Jeffrey M. Hunter, OCP
Sr. Database Administrator
jhunter@idevelopment.info
http://www.idevelopment.info
----------------------------