The versions of my database and report services are as follows:
Database: SQL Server 2008 R2
Reporting Services: SQL Server 2008 R2 Reporting Services
I wanted to get users to access my report services like a Web site, and the Damned SQL Server Reporting Services did not rely on IIS since 2005, causing users to not be able to access them anonymously.
There is a tutorial on "SQL Server 2008 Reporting Services anonymous Access" on the Web, which is implemented by modifying the configuration files under Reporting services, and I did it again without success.
It suddenly occurred to me that I was just allowing access to the user account with permission, and it was not necessary to implement anonymous access. When someone uses another computer to access the service always prompts "No permissions", and the person's account is added to the server's Administrators group can be accessed, other groups are not accessible. So I wonder if the access to the Reporting Services configuration item is open only to admin? After proving my inference to be correct, I also found the SSRs method for using user login, as follows:
1, with the administrator into the Report Manager url:http://localhost/reports
2, the "security" of the home folder, new role assignment, add the Users group
3, into the upper right corner of the "Site Settings", new role assignment, the Users group added
4, into the "Folder Settings", new role assignment, the Users group added
That is, add the Users group to the appropriate permissions for the site and folder.
Finally solved, almost put the database back to SQL Server 2000.
The above mentioned is the entire content of this article, I hope you can enjoy.