SQL Server 2008 Reporting Services实现匿名访问报表

实现SQL Server 2008 Reporting Services匿名访问报表有两种方法。

一、通过修改SQL Server 2008的配置文件，去掉Windows的验证。

1.首先我们找到SQL安装目录下的两个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" />

 

 

2.找到（C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer）目录下的rsreportserver.config文件，找到配置文件中的

<Authentication> 
    <AuthenticationTypes> 
        <RSWindowsNegotiate/> 
        <RSWindowsNTLM/>
     </AuthenticationTypes> 
     <RSWindowsExtendedProtectionLevel>Off</RSWindowsExtendedProtectionLevel> 
     <RSWindowsExtendedProtectionScenario>Proxy</RSWindowsExtendedProtectionScenario> 
     <EnableAuthPersistence>true</EnableAuthPersistence> 
</Authentication>

将其改为： 

<Authentication> 
    <AuthenticationTypes> 
        <Custom/>
    </AuthenticationTypes> 
    <RSWindowsExtendedProtectionLevel>Off</RSWindowsExtendedProtectionLevel> 
    <RSWindowsExtendedProtectionScenario>Proxy</RSWindowsExtendedProtectionScenario> 
    <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>

 

这里需要引用一个DLL文件，就是Microsoft.Samples.ReportingSerices.
 
3.将dll放入到目录C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer\bin，接下来继续修改我们的配置文件，在（C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer）目录下，找到rssrvpolicy.config找到

<CodeGroup class="FirstMatchCodeGroup" version="1" PermissionSetName="Nothing">
<IMembershipCondition class="AllMembershipCondition" version="1" /> 

 

在其下边追加如下节点（红色部分，按照你的实际路径而定）

<CodeGroup class="UnionCodeGroup" version="1" PermissionSetName="FullTrust" Name="Private_assembly" Description="This code grou p grants custom code full trust."> 
<IMembershipCondition class="UrlMembershipCondition" version="1" Url="C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER2008\Reporting Services\ReportServer\bin\Microsoft.Samples.ReportingServices.AnonymousSecurity.dll"/> 
</CodeGroup> 

 

到此为止，我们匿名登录的方式，配置工作就完成了。
 
二、利用接口IReportServerCredentials 和IReportServerConnection将Windows的用户名和密码传进去以实现匿名访问报表。
1.利用IReportServerCredentials 接口
接口定义为：

using System;
using Microsoft.Reporting.WebForms;
using System.Net;
using System.Security.Principal;
using System.Configuration;

namespace SqlReport
{
    [Serializable]
    class MyConfigFileCredentials : IReportServerCredentials
    {
        public MyConfigFileCredentials()
        {
        }

        public WindowsIdentity ImpersonationUser
        {
            get
            {
                return null;
            }
        }

        public ICredentials NetworkCredentials
        {
            get
            {
                return new NetworkCredential("Administrator","123456");//windows的用户名和密码
            }
        }

        public bool GetFormsCredentials(out Cookie authCookie, out string userName, out string password, out string authority)
        {
            authCookie = null;
            userName = null;
            password = null;
            authority = null;
            return false;
        }
    }  
}

 

 

在调用报表的代码如下：

using System;
using System.Web;
using Microsoft.Reporting.WebForms;


namespace SqlReport
{
    public partial class _Default : System.Web.UI.Page
    {

        protected void Page_Load(object sender, EventArgs e)
        {
            if ((!IsPostBack) && Request.QueryString.Count > 0)
            {
                string reportPath = Request.QueryString[0];
                this.ReportLabel.Text = Request.QueryString[0];
             
                this.ReportViewer3.ProcessingMode = ProcessingMode.Remote;
                MyConfigFileCredentials rsc = new MyConfigFileCredentials();

                this.ReportViewer3.ServerReport.ReportServerCredentials = rsc;
                this.ReportViewer3.ServerReport.ReportPath = reportPath;
                this.ReportViewer3.ServerReport.ReportServerUrl = new Uri((Properties.Settings.Default.MyReportServerUrl));
                this.ReportViewer3.ServerReport.Refresh();
            }
        }
    }
}

  

 

2.利用IReportServerConnection接口，接口定义：

using System;
using System.Collections.Generic;
using System.Net;
using System.Security.Principal;
using Microsoft.Reporting.WebForms;

namespace SqlReport
{
    [Serializable]
    public class MyReportServerConnection : IReportServerConnection
    {
        public Uri ReportServerUrl
        {
            get
            {
                string url = Properties.Settings.Default.MyReportServerUrl;
                if (string.IsNullOrEmpty(url))
                    throw new Exception("Missing url from the Web.config file");
                return new Uri(url);
            }
        }
        public int Timeout
        {
            // set timeout to 60 seconds
            get { return 60000; }
        }

        public IEnumerable<Cookie> Cookies
        {
            // No custom cookies
            get { return null; }
        }
        public IEnumerable<string> Headers
        {
            // No custom headers
            get { return null; }
        }

        public MyReportServerConnection()
        {
        }


        public WindowsIdentity ImpersonationUser
        {
            get { return null; }
        }

        public ICredentials NetworkCredentials
        {
            get
            {
                //this will force the use of impersonation, 
                // otherwise, remove the return null and 
                // implement the other app settings to specify the credential details
                // return null;
                string userName = Properties.Settings.Default.myReportViewerUser;
                if (string.IsNullOrEmpty(userName))
                    throw new Exception("Missing user name from Web.config file");
                string password = Properties.Settings.Default.MyReportViewerPassword;
                if (string.IsNullOrEmpty(password))
                    throw new Exception("Missing password from Web.config file");
                string domain = Properties.Settings.Default.MyReportViewerDomain;
                if (string.IsNullOrEmpty(domain))
                    throw new Exception("Missing domain from Web.config file");
                return new NetworkCredential(userName, password, domain);
                //return new NetworkCredential(userName, password);
            }
        }

        public bool GetFormsCredentials(out Cookie authCookie, out string userName, out string password, out string authority)
        {
            authCookie = null;
            userName = null;
            password = null;
            authority = null;
            return false;
        }
    }
}

 

 在调用报表的代码如下：

using System;
using System.Web;
using Microsoft.Reporting.WebForms;


namespace SqlReport
{
    public partial class _Default : System.Web.UI.Page
    {

        protected void Page_Load(object sender, EventArgs e)
        {
            if ((!IsPostBack) && Request.QueryString.Count > 0)
            {
                string reportPath = Request.QueryString[0];
                this.ReportLabel.Text = Request.QueryString[0];
              
                this.ReportViewer3.ProcessingMode = ProcessingMode.Remote;
                MyReportServerConnection rsc = new MyReportServerConnection();

                this.ReportViewer3.ServerReport.ReportServerCredentials = rsc;
                this.ReportViewer3.ServerReport.ReportPath = reportPath;
                this.ReportViewer3.ServerReport.ReportServerUrl = new Uri((Properties.Settings.Default.MyReportServerUrl));
                this.ReportViewer3.ServerReport.Refresh();
            }
        }
    }
}

  

 

 

ok,到此就可以实现了。