SSRS Anonymous Access

Source: Internet
Author: User

---My database is SqlServer2008 R2 anonymous access reporting Service 2008

I want to access the URL to integrate the report deployed to the SQL Server Reporting Service into the Web application, but the direct access address always prompts for credentials, looking for several methods on the Internet, and extracts one: Reportingservice is a very powerful reporting engine! However, the implementation of reporting Service2008 Anonymous access is a laborious thing, the online method is quite a lot of, but not for the use of URL access.

RS2005 relies on IIS for Anonymous Logon access using the anonymous account of IIS. RS2008 does not rely on IIS, which means it cannot be accessed through the anonymous account of IIS, which means that you need to enter a valid user name and password for your visit.

------The following is the anonymous access to reporting Service 2008 Step 1, locate the RS2008 installation directory, if you are a 64-bit system, and the installation is 64-bit MSSQL2008, and is the default path installation, please go to folder: C:\Program Files\Microsoft SQL Server\msrs10_50.mssqlserver\reporting Services Otherwise please follow your own settings to find.

2. Backup files (note folders):

①\reportserver\web.config

②\reportserver\rsreportserver.config

③\reportmanager\web.config

3, modify ①, ③ two files

Find:

<authentication mode= "Windows"/> <identity impersonate= "true"/> Replaced by:

<authentication mode= "None"/> <identity impersonate= "false"/> 4, modify ② file

Find:  <AuthenticationTypes>     <RSWindowsNegotiate/>      <RSWindowsNTLM/>  </AuthenticationTypes> replaced by:  <AuthenticationTypes>      <Custom/>  </AuthenticationTypes> Find:  <Security>     <extension name= "Windows" type= "Microsoft.ReportingServices.Authorization.WindowsAuthorization, Microsoft.ReportingServices.Authorization "/>  </Security>  <Authentication>     <extension name= "Windows" type= "Microsoft.ReportingServices.Authentication.WindowsAuthentication, Microsoft.ReportingServices.Authorization "/>  </Authentication> Replace with:  <Security>     <extension name= "None" type= "Microsoft.Samples.ReportingServices.AnonymousSecurity.Authorization, Microsoft.Samples.ReportingServices.AnonymousSecurity "/>  </Security>  <Authentication>     <extension name= "None" type= " Microsoft.Samples.ReportingServices.AnonymousSecurity.AuthenticationExtension, Microsoft.Samples.ReportingServices.AnonymousSecurity "/>  </Authentication>

5. Download file: Microsoft.Samples.ReportingServices.AnonymousSecurity.dll extract to save to directory "\reportserver\bin\" folder.

At this end of the configuration, restart the RS service.

This article is quoted from: http://tedeum.iteye.com/blog/1208232 5th of the file download path: http://files.cnblogs.com/files/xymBlog/%E5%8C%BF%E5%90%8D% E8%ae%bf%e9%97%aereportingservice2008.rar

SSRS Anonymous Access

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.