相关参考资料：

Anonymous access in SQL RS 2008

http://blogs.msdn.com/b/jameswu/archive/2008/07/15/anonymous-access-in-sql-rs-2008.aspx

 

Microsoft SQL SERVER 2008 R2 REPORT SERVICE 匿名登录

http://blog.sina.com.cn/s/blog_7778950d0100qa61.html

 

 

1、修改文件rsreportserver.config，默认位置在C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer目录下

<Authentication>

<AuthenticationTypes>

<RSWindowsNegotiate/>

<RSWindowsNTLM/>

</AuthenticationTypes>

<RSWindowsExtendedProtectionLevel>Off</RSWindowsExtendedProtectionLevel>

<RSWindowsExtendedProtectionScenario>Proxy</RSWindowsExtendedProtectionScenario>

<EnableAuthPersistence>true</EnableAuthPersistence>

 

修改为

<Authentication>

<AuthenticationTypes>

<Custom/>

</AuthenticationTypes>

<RSWindowsExtendedProtectionLevel>Off</RSWindowsExtendedProtectionLevel>

<RSWindowsExtendedProtectionScenario>Proxy</RSWindowsExtendedProtectionScenario>

<EnableAuthPersistence>true</EnableAuthPersistence></Authentication>

 

 

2、修改ReportServer和ReportManager目录下的web.config文件

<authentication mode="Windows" />
<identity impersonate="true" />

 

修改为

<authentication mode="None" />
<identity impersonate="false" />

 

3、将“Microsoft.Samples.ReportingServices.AnonymousSecurity.dll”文件放入到bin目录，默认路径为“C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer”

 

4、修改ReportServer目录下的rsreportserver.config文件

  <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>

 

修改为：

  <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、修改ReportServer目录下的rssrvpolicy.config文件，追加如下内容

 <CodeGroup

class="UnionCodeGroup"

version="1"

PermissionSetName="FullTrust"

Name="Private_assembly"

Description="This code group grants custom code full trust. ">

<IMembershipCondition

class="UrlMembershipCondition"

version="1"

Url="C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer\bin\Microsoft.Samples.ReportingServices.AnonymousSecurity.dll"/>

</CodeGroup>

 

6、重启reporting service服务

 

相关修改好的配置文件和dll文件放置在如下下载中