I am trying to test some reports and a report model built under VS-2005 under the Report Server and am NOT getting the content or property pages under folder.aspx, i.e., what typically shows when you run http://localhost\Reports.
Currently, http://localhost\Reports prompts me for my Windows login and password.
Was able to go in under SQL Server Management Studio connect to Report Services and add my local user account by granting it permissions. This enabled the "Site Settings" link at the upper right hand corner. So I am able to edit "Site Settings -- but not look at content.
Under http://localhost/ReportServer I get the infamous message: the permissions granted to user 'myMachine\mySelf' are insufficient for performing this operation (rsAccessDenied).
I am using Vista Ultimate, with IIS 7 / VS-2005 / SP1, SQL-Server 2005/SP2 on a home machine (not a corporate network).
Here are the steps for dealing with rsAccessDenied problem...
Follow the steps under KB934164.
Run SQL-Server 2005 Management Studio as as "Administrator" -- Connect to the Report Services Engine.
Step 1:
Right Click "localHost", go the Permissions page and grant your Service account permission. Also add your username for your Administrators.
Step 2:
Go down one level to "HOME". right click on Permission page and add you users or groups.
After doing this, I was able to see the Content page.
I received an access denied message when running a report against the Adventure Works database. Error messages such as "could not load file or asembly or dependencies.
Follow the "Hot To: Create a Service Account for an ASP.NET 2.0 Application. (Aspnet_regiis - ga ... ). This is under the patterns and practices under msdn2. ms998297.
This with applying settings under the Report Services Configuration utility seemed to address the problem.
No comments:
Post a Comment