• 设置sql2008ReportServer报表匿名访问的办法,亲测可用


    1.将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>

    4.重启报表服务器的reporting service。
     
  • 相关阅读:
    CentOS6.5配置网络
    php curl 总结
    laravel-5-doctrine-2 教程
    DOS 总结
    Centos如何通过yum安装php7
    sql with 写法
    php 汉字转拼音函数
    MYSQL 升序排序但值为0的排最后
    zookeeper基础知识
    初识redis
  • 原文地址:https://www.cnblogs.com/renshaoqun/p/3050503.html
Copyright © 2020-2023  润新知