SQL Server 2008+ Reporting Services (SSRS) uses user logon issues _mssql2008

Source: Internet
Author: User
Tags anonymous

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.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.