Anonymous access in SQL RS 2008 | Reporting Service for SQL 2008匿名訪問報表方法


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

http://blogs.msdn.com/jameswu/archive/2008/10/24/anonymous-access-in-sql-rs-2008-part-2.aspx


Reporting Service for SQL 2008匿名訪問報表方法

-----------------SQL2008安裝到C為例


1.
AnonymousSecurity.cs編譯Microsoft.Samples.ReportingServices.AnonymousSecurity.dll,拷貝這個DLL
C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer\bin

 

2.修改兩個web.config配置檔
(位於
C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer
C:\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
(位於C:\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>





优质内容筛选与推荐>>
1、AIX 系统介绍
2、java 连接SQLServer No suitable driver found for jdbc
3、新增一自增列
4、feel better about yourself 完美破解MyEclipse 5.5.1 GA 注册码呵呵
5、ruby字符串处理


长按二维码向我转账

受苹果公司新规定影响,微信 iOS 版的赞赏功能被关闭,可通过二维码转账支持公众号。

    阅读
    好看
    已推荐到看一看
    你的朋友可以在“发现”-“看一看”看到你认为好看的文章。
    已取消,“好看”想法已同步删除
    已推荐到看一看 和朋友分享想法
    最多200字,当前共 发送

    已发送

    朋友将在看一看看到

    确定
    分享你的想法...
    取消

    分享想法到看一看

    确定
    最多200字,当前共

    发送中

    网络异常,请稍后重试

    微信扫一扫
    关注该公众号