Permission issues that may occur when reporting services is configured in Vista and Their Solutions

When Microsoft SQL Server 2008/7 Reporting Services is configured in Windows Vista/Server 2008, some permission problems may occur. When you access http: // localhost/reportserver, the system prompts that the "*" user is not authorized enough to perform this operation. (Rsaccessdenied ). When accessing http: // localhost/reports, only a small part of content on the top is displayed, and the following is blank.

For more information, see http://msdn.microsoft.com/zh-cn/library/bb6302.16.aspx. But sometimes thisArticleThe method described in may not be able to solve the problem. Some articles on the Internet introduced how to solve this problem by configuring IIS virtual directory permissions, but version 2008 is no longer dependent on IIS (http://blogs.technet.com/andrew/archive/2007/12/04/sql-server-2008-reporting-services-no-longer-depends-on-iis.aspx), so this method cannot be solved.

To solve this problem, I first disable UAC and restart it, then enable http: // localhost/reports, log on with the Administrator account, select the "attribute" label, and create a new role assignment, enter the user name and select a role. Enable UAC and restart to add http: // localhost/to a trusted site. Log on to the reporting services site with the username you added earlier.