关于SQL2008报表服务远程访问弹出验证的解决方法-优快云博客

关于SQL2008报表服务远程访问弹出验证的解决方法

-------------------------------------------以SQL2008安装到D盘为例----------------------------------
1.将代码（代码太长,用另一篇文章发布（结果还是提示文章太长，百度太小气了，没办法，需要的留个Email吧））编译为Microsoft.Samples.ReportingServices.AnonymousSecurity.dll,
拷贝这个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
(位于D:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer）
将
<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>

搞定,收工.