Microsoft SQL SERVER R2 report SERVICE Anonymous Logon

SQL Server R2 is Microsoft's current version of the database, in the previous SQL Server 2005, we can modify the SSRS site for IIS and SSRS configuration file, SSRs configured as an anonymous login, the report is integrated into the system, And now SSRS2008 R2 has been completely separated from IIS, so that we are in the use of 2005 configuration method is not feasible, in order to let everyone better understand, the following will give you a brief introduction of my development process, encountered the integration of SSRS report scenario. Different integrations have different solutions.

Integration of SSRS reports in  1, ASP, and in this way, we typically use the Report Viewer control to show the reports, in which case, if we don't do any of the processing, When the client accesses our report, it will prompt for the Window authentication input box, we can only enter the user name and password to access the report properly, in this scenario, if we want to remove the Windows validation box, we could implement an interface for SSRS ( Ireportservercredential), which provides three forms of authentication for the report (Windowscredential, Networkcrendtial, formcredential), And we're going to use the second type of authentication method. We need to implement the methods in the interface, new NetworkCredential (Username,password,domain) and then set the credential property of the Report Viewer to the object we implement the interface class. This indirectly implements our report anonymous login.   Of course, in the first scenario, we can also use SSRS WebService, the current version of WebService has 2005, 20,102 versions, add webservice directly to the reference (Http://hostname:port /reportserver/reportservice2005.asmx or Reportservice2010.asmx), here is not the detailed said.  2, the second way is to integrate SSRS reports in SharePoint, in this way, we generally adopt the way of deployment, we can solve the problem of SSRS access, we generally adopt the installation of SSRS, SharePoint integrated mode, So SSRS inherits permission management from SharePoint, and all we have to do is to do the right control of SharePoint.   3, the Third Way, is also the most important way we recommend today, is to implement SSRS in the true sense of anonymous login by modifying the configuration file and adding the assembly. Next I will introduce the steps to you.    3 (1), first we find the two Web. config profiles in the SSRS installation directory, the default installation directory is (C:\Program Files\Microsoft SQL Server\msrs10_ 50.mssqlserver\reporting Services\ReportServer and C:\pRogram Files\Microsoft SQL Server\msrs10_50.mssqlserver\reporting Services\ReportManager), and then found two configuration files in < Authentication mode= "Windows"/>      <identity impersonate= "true"/>  Change it to <authentication mode= "None"/>  <identity impersonate= "false"/>  3 (2), found (c \ Program Files\Microsoft SQL Server\msrs10_50.mssqlserver\reporting Services\ ReportServer) directory, locate the RSReportServer.config file in the configuration file  <Authentication> <AuthenticationTypes> < rswindowsnegotiate/> <RSWindowsNTLM/> </AuthenticationTypes> <rswindowsextendedprotectionlevel >Off</RSWindowsExtendedProtectionLevel> <rswindowsextendedprotectionscenario>proxy</ Rswindowsextendedprotectionscenario> <EnableAuthPersistence>true</EnableAuthPersistence> </ authentication>  change it to <Authentication> <AuthenticationTypes> <Custom/> </ Authenticationtypes> <rswindowsextendedprotectionlevEl>off</rswindowsextendedprotectionlevel> <rswindowsextendedprotectionscenario>proxy</ Rswindowsextendedprotectionscenario> <EnableAuthPersistence>true</EnableAuthPersistence> </ authentication>  then locate the  <security>   <extension Name= "Windows" Type= in the configuration file Microsoft.ReportingServices.Authorization.WindowsAuthorization, Microsoft.ReportingServices.Authorization "/> </Security> <authentication>   <extension name= "Windows" type= " Microsoft.ReportingServices.Authentication.WindowsAuthentication, Microsoft.ReportingServices.Authorization "/ > </Authentication>  change it to  <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> from the top two nodes we can see that we need to reference a DLL file, which isMicrosoft.Samples.ReportingServices.AnonymousSecurity.dll, we need to put this DLL into (C:\Program Files\Microsoft SQL Server \msrs10_50.mssqlserver\reporting Services\ReportServer\bin) directory.    3 (3), after putting the DLL into the directory, we continue to modify our configuration file in (C:\Program Files\Microsoft SQL Server\msrs10_50.mssqlserver\ Reporting services\reportserver) directory, find rssrvpolicy.config find <codegroup class= "FirstMatchCodeGroup" version= "1" Permissionsetname= "Nothing" > <imembershipcondition class= "allmembershipcondition" version= "1"/> Append the following nodes below (red section, depending on your actual path)  <codegroup class= "Unioncodegroup"   version= "1"                                                                   permissionsetname= "FullTrust"   name= "private_assembly"   description= "This Code grou p grants custom code full trust." >                             <imembershipcondition class= "UrlMembershipCondition"         version= "1"   url= "C:\Program Files\Microsoft SQL

server\msrs10_50.mssqlserver2008\reporting services\reportserver\bin\ Microsoft.Samples.ReportingServices.AnonymousSecurity.dll"/>

</CodeGroup>

So far, the way we log on anonymously, the configuration is done, and below I will have a few wrong ways to resolve the error when I access the report after the configuration is complete. Blog original: http://blog.sina.com.cn/s/blog_7778950d0100qa61.html dll download Ssrs_onekey_nologin.zip

Microsoft SQL SERVER R2 report SERVICE Anonymous Logon