导航

设置SQL2008报表匿名访问的方法

Posted on 2011-01-21 15:37  Rainbow.ding  阅读(742)  评论(0)  编辑  收藏  举报

设置SQL2008报表匿名访问的方法

安照下面的步骤操作可以将SQL2008报表配置成匿名访问，其中的Microsoft.Samples.ReportingServices.AnonymousSecurity.dll大家可以把邮箱留下，我会在看到之后给你发过去。

1. 拷贝Microsoft.Samples.ReportingServices.AnonymousSecurity.dll到
D:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer\bin

2.修改配置文件web.config(D:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer
   D:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportManager)
将
    <authentication mode="Windows" />
    <identity impersonate="true"/>
修改为:
    <authentication mode="None" />
    <identity impersonate="false"/>

3.修改配置文件rereportserver.config
将
 <Authentication>
  <AuthenticationTypes>
   <RSWindowsNegotiate/>
   <RSWindowsNTLM/>
  </AuthenticationTypes>
  <EnableAuthPersistence>true</EnableAuthPersistence>
 </Authentication>
修改为：
            <Authentication>
  <AuthenticationTypes>
   <Custom/>
  </AuthenticationTypes>
  <EnableAuthPersistence>true</EnableAuthPersistence>
            </Authentication>


在

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