This is a very short blog post related to the administration of the SQL Server Reporting Services. This particular post is related to an installation of SQL Server 2008 reporting services on Windows Vista. roblem: After attempting to access the http://localhost/reportserver the first time after SQL Server installation on Windows Vista, the SQL Server Reporting Services show the following error:

"Reporting Services Error: The permissions granted to user
'someDomain\someUser' are insufficient for performing this operation.
(rsAccessDenied) Get Online Help".

Solution:

1. Open your SSMS as an administrator. (This is very IMPORTANT! Right-click on the SQL Server Management Studio icon and then click "Run as Administrator")

2. Connect to Reporting Services...

3. For Server Name field type in localhost

4. After you are connected to the Reporting Server, right-click the Home directory and click Properties.

5. Click on "Add group or user", type in the user name in the following format: someDomain\someUser

6. Check the appropriate checkboxes to give permissions.

This is all.