时间戳

首页 > 解决方案 > 自动化 SSRS 配置 C#

c# - 自动化 SSRS 配置 C#

问题描述

我正在尝试创建一个可以运行的程序来自动配置 MSRS13 的报告服务。

代码正确地将证书复制到受信任的根存储中。代码正确地将 URL 信息复制到 RSReportingServer.Config，但是当我尝试启动 URL 时，我收到 404 错误。如果我打开配置管理器进行调试并点击应用 Url 工作，我不再得到 404。我尝试以 SYSTEM 和 LOCAL SERVICE 身份运行，但没有成功。反正有没有通过c#配置这些设置？

我尝试使用 RSConfig 更改服务帐户以作为系统运行，但我收到有关未安装 .net Framework 3.5 的错误，然后在安装它时遇到无效命名空间错误。我也希望不要将服务帐户更改为默认值，但如果我可以将其更改回来，我愿意更改它。

SSRSConfig(string thumbprint, string instanceName){

X509Certificate2 x509 = GetCertificateByThumbprint(thumbprint);
if (x509 != null)
{
    X509Store store = new X509Store(StoreName.Root, StoreLocation.LocalMachine);
    try
    {
        store.Open(OpenFlags.ReadWrite);
        store.Add(x509);
    }
    catch (Exception e)
    {
        LoggingManager.ErrorFormat(typeof(CLsiCertUtil), "Failed to add cert to trusted store {0}", e.Message);
        exitCode = CertExitCodes.AddCertError;
    }
    finally
    {
        store.Close();
    }
}
else
{
    LoggingManager.Warn(typeof(CLsiCertUtil), "Cert not found in Personal store. Not porting to Trusted root. Cert may need moved by hand.");
}

string inputPath = "C:\\Program Files\\Microsoft SQL Server\\MSRS13." + instanceName + "\\Reporting Services\\ReportServer\\RSReportServer.config";
FileInfo fi = new FileInfo(inputPath);
if (fi.Exists) fi.IsReadOnly = false;

XDocument xdHttp = XDocument.Load(inputPath);
LoggingManager.InfoFormat(typeof(CLsiCertUtil), "Processing config: \"{0}\"", inputPath);

XElement xeHttpRoot = xdHttp.Root;

if (xeHttpRoot == null)
{
    LoggingManager.ErrorFormat(typeof(CLsiCertUtil), "ERROR: Unable to find root xml element for configuration: \"{0}\"", inputPath);
    return;
}

//Find the sub element that contains the comment
XElement xeSSLCertificateConfiguration = xeHttpRoot.Elements().Where(c => c.Name.ToString().Equals("SSLCertificateConfiguration")).FirstOrDefault();

if (xeSSLCertificateConfiguration == null)
{
    XElement bindings =
        new XElement("Bindings",
            new XElement("Binding",
                new XElement("ApplicationName", "ReportServerWebService"),
                new XElement("CertificateHash", thumbprint),
                new XElement("IPAddress", "0.0.0.0"),
                new XElement("Port", "443")),
            new XElement("Binding",
                new XElement("ApplicationName", "ReportServerWebService"),
                new XElement("CertificateHash", thumbprint),
                new XElement("IPAddress", "::"),
                new XElement("Port", "443")),
            new XElement("Binding",
                new XElement("ApplicationName", "ReportServerWebApp"),
                new XElement("CertificateHash", thumbprint),
                new XElement("IPAddress", "0.0.0.0"),
                new XElement("Port", "443"),
            new XElement("Binding",
                new XElement("ApplicationName", "ReportServerWebApp"),
                new XElement("CertificateHash", thumbprint),
                new XElement("IPAddress", "::"),
                new XElement("Port", "443")
                ))
            );
    xeHttpRoot.Add(new XElement("SSLCertificateConfiguration", bindings));
}

//Find the sub element that contains the comment
XElement xeURLReservations = xeHttpRoot.Elements().Where(c => c.Name.ToString().Equals("URLReservations")).FirstOrDefault();

if(xeURLReservations !=  null)
{
    IEnumerable<XElement> listApp = xeURLReservations.Elements();
    foreach (XElement xeApp in listApp)
    {
        string strAccountSid = "";
        string strAccountName = "";
        XElement xeURLs = xeApp.Elements().Where(c => c.Name.ToString().Equals("URLs")).FirstOrDefault();
        if(xeURLs != null)
        {
            XElement xeURL = xeURLs.Elements().Where(c => c.Name.ToString().Equals("URL")).FirstOrDefault();
            if (xeURL != null)
            {
                XElement xeAccountSid = xeURL.Elements().Where(c => c.Name.ToString().Equals("AccountSid")).FirstOrDefault();
                if (xeAccountSid != null)
                {
                    strAccountSid = xeAccountSid.Value.ToString();
                }
                XElement xeAccountName = xeURL.Elements().Where(c => c.Name.ToString().Equals("AccountName")).FirstOrDefault();
                if (xeAccountName != null)
                {
                    strAccountName = xeAccountName.Value.ToString();
                }
            }

            if(!string.IsNullOrWhiteSpace(strAccountSid) && !string.IsNullOrWhiteSpace(strAccountName))
            {
                string strUrl = "https://" + x509.Subject.Substring(3) + ":443";
                XElement newUrl =
                    new XElement("URL",
                        new XElement("UrlString", strUrl),
                        new XElement("AccountSid",strAccountSid),
                        new XElement("AccountName",strAccountName)
                        );
                xeURLs.Add(newUrl);
            }
        }

    }
}

//save the local xml to the web.config
xdHttp.Save(inputPath);
}

非常感谢任何帮助我已经研究了几周但没有进展。让我知道是否有更多信息会有所帮助。

这是 Reporting Services 日志

<Header>
  <Product>Microsoft SQL Server Reporting Services Version 13.0.5026.0</Product>
  <Locale>en-US</Locale>
  <TimeZone>Pacific Standard Time</TimeZone>
  <Path>C:\Program Files\Microsoft SQL Server\MSRS13.SYSMGMT_DB\Reporting Services\LogFiles\Microsoft.ReportingServices.Portal.WebHost_03_12_2021_08_51_28.log</Path>
  <SystemName>TB-84MASTER</SystemName>
  <OSName>Microsoft Windows NT 6.2.9200.0</OSName>
  <OSVersion>6.2.9200.0</OSVersion>
</Header>
Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!1!03/12/2021-08:51:28:: i INFO: Setting up Debug CRT libraries
Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!1!03/12/2021-08:51:28:: w WARN: %_NTDRIVE% not defined... Skipping
Microsoft.ReportingServices.Portal.WebHost!library!1!03/12/2021-08:51:28:: i INFO: SQLDump flags: ReferencedMemory, AllThreads, SendToWatson
Microsoft.ReportingServices.Portal.WebHost!library!1!03/12/2021-08:51:28:: i INFO: MiniDump flags: DataSegs, UnloadedModules, ProcessThreadData
Microsoft.ReportingServices.Portal.WebHost!library!1!03/12/2021-08:51:28:: i INFO: Dump on: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogExceptionMicrosoft.ReportingServices.Modeling.InternalModelingExceptionMicrosoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException
Microsoft.ReportingServices.Portal.WebHost!library!1!03/12/2021-08:51:28:: i INFO: Do not dump on: System.Threading.ThreadAbortExceptionSystem.Web.UI.ViewStateExceptionSystem.OutOfMemoryExceptionSystem.Web.HttpExceptionSystem.IO.IOExceptionSystem.IO.FileLoadExceptionMicrosoft.SharePoint.SPExceptionMicrosoft.ReportingServices.WmiProvider.WMIProviderExceptionSystem.AppDomainUnloadedException
Microsoft.ReportingServices.Portal.WebHost!library!1!03/12/2021-08:51:28:: i INFO: Minidump location: C:\Program Files\Microsoft SQL Server\MSRS13.SYSMGMT_DB\Reporting Services\LogFiles
Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!1!03/12/2021-08:51:28:: i INFO: Starting ReportServerWebApp
Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!1!03/12/2021-08:51:28:: i INFO: Working directory : C:\Program Files\Microsoft SQL Server\MSRS13.SYSMGMT_DB\Reporting Services\RSWebApp
Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!1!03/12/2021-08:51:28:: i INFO: Report Server url: http://localhost:80/ReportServer_SYSMGMT_DB
Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!1!03/12/2021-08:51:28:: i INFO: Report Server Web App virtual root: /Reports_SYSMGMT_DB
Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!1!03/12/2021-08:51:28:: i INFO: Web app url: http://+:80/Reports_SYSMGMT_DB/
Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!1!03/12/2021-08:51:28:: i INFO: Web app url: https://TB-84Master.lslab.org:443/Reports_SYSMGMT_DB/
Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!1!03/12/2021-08:51:28:: i INFO: Web app url: https://TB-84Master.lslab.org:443/Reports_SYSMGMT_DB/
Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!1!03/12/2021-08:51:28:: i INFO: Authentication scheme(s): Ntlm
Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!1!03/12/2021-08:51:28:: i INFO: Registering 0    : AuthSchemeConfig
Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!1!03/12/2021-08:51:28:: i INFO: Registering 5    : RequestLoggingConfig
Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!1!03/12/2021-08:51:28:: i INFO: Registering 10   : CustomAuthenticationConfig
Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!1!03/12/2021-08:51:28:: i INFO: Registering 20   : BasicAuthenticationConfig
Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!1!03/12/2021-08:51:28:: i INFO: Registering 25   : RequestThrottlingConfig
Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!1!03/12/2021-08:51:28:: i INFO: Registering 30   : CsrfTokenCreationConfig
Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!1!03/12/2021-08:51:28:: i INFO: Registering 40   : LanguageConfig
Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!1!03/12/2021-08:51:28:: i INFO: Registering 50   : XFrameOptionsConfig
Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!1!03/12/2021-08:51:28:: i INFO: Registering 50   : ClassicUrlRedirecterConfig
Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!1!03/12/2021-08:51:28:: i INFO: Registering 50   : PopulateHeadersConfig
Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!1!03/12/2021-08:51:28:: i INFO: Registering 53   : LocalRequestMiddlewareConfig
Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!1!03/12/2021-08:51:28:: i INFO: Registering 55   : ClassicUrlRewriterConfig
Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!1!03/12/2021-08:51:28:: i INFO: Registering 60   : ResponseCompressionConfig
Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!1!03/12/2021-08:51:28:: i INFO: Registering 100  : FileSystemConfig
Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!1!03/12/2021-08:51:28:: i INFO: Registering 190  : ServiceUnavailableConfig
Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!1!03/12/2021-08:51:28:: i INFO: Registering 200  : DatabaseAvailableConfig
Microsoft.ReportingServices.Portal.WebHost!crypto!1!03/12/2021-08:51:28:: i INFO: Initializing crypto as user: NT Service\ReportServer$SYSMGMT_DB
Microsoft.ReportingServices.Portal.WebHost!crypto!1!03/12/2021-08:51:28:: i INFO: Exporting public key
Microsoft.ReportingServices.Portal.WebHost!crypto!1!03/12/2021-08:51:28:: i INFO: Importing existing encryption key
Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!1!03/12/2021-08:51:28:: i INFO: Registering 300  : CsrfTokenValidationConfig
Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!1!03/12/2021-08:51:28:: i INFO: Registering 500  : WebApiOwinConfig
Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!1!03/12/2021-08:51:29:: i INFO: Registering 600  : ODataWebApiOwinConfig
Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!1!03/12/2021-08:51:30:: e ERROR: Unhandled exception: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Net.HttpListenerException: Access is denied
   at System.Net.HttpListener.AddAllPrefixes()
   at System.Net.HttpListener.Start()
   at Microsoft.Owin.Host.HttpListener.OwinHttpListener.Start(HttpListener listener, Func`2 appFunc, IList`1 addresses, IDictionary`2 capabilities, Func`2 loggerFactory)
   at Microsoft.Owin.Host.HttpListener.OwinServerFactory.Create(Func`2 app, IDictionary`2 properties)
   --- End of inner exception stack trace ---
   at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
   at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
   at Microsoft.Owin.Hosting.ServerFactory.ServerFactoryAdapter.Create(IAppBuilder builder)
   at Microsoft.Owin.Hosting.Engine.HostingEngine.Start(StartContext context)
   at Microsoft.Owin.Hosting.Starter.HostingStarter.Start(StartOptions options)
   at Microsoft.ReportingServices.Portal.WebHost.Services.Impl.WebAppWrapper.Start(StartOptions options)
   at Microsoft.ReportingServices.Portal.WebHost.Services.Impl.WebAppServiceController.Start()
   at Microsoft.ReportingServices.Portal.WebHost.Program.Run()
   at Microsoft.ReportingServices.Portal.WebHost.Program.Main(String[] args).

我继续测试了几天，仍然空手而归。如果我将网络列表服务和 SSRS 帐户更改为以用户或系统身份运行，我的代码就可以工作。但我需要能够在代码中做到这一点。

标签： c#reporting-servicessqlreportingservice

解决方案

我最终没有找到通过直接调整配置文件来做到这一点的方法。我确实找到了可以为我运行它的 PowerShell 类。我使用了以下代码：

string script = string.Format(@"$wmiName = (Get-WmiObject –namespace root\Microsoft\SqlServer\ReportServer  –class __Namespace).Name
    $rsConfig = Get-WmiObject –namespace ""root\Microsoft\SqlServer\ReportServer\$wmiName\v13\Admin"" -class MSReportServer_ConfigurationSetting -filter ""InstanceName = '{2}'""

    $rsConfig.ReserveURL(""ReportServerWebService"", ""https://{0}:443/"", 1033)
    $rsConfig.CreateSSLCertificateBinding(""ReportServerWebService"", ""{1}"", ""0.0.0.0"", 443, 1033)
    $rsConfig.CreateSSLCertificateBinding(""ReportServerWebService"", ""{1}"", ""::"", 443, 1033)
    $rsConfig.ReserveURL(""ReportServerWebApp"", ""https://{0}:443/"", 1033)
    $rsConfig.CreateSSLCertificateBinding(""ReportServerWebApp"", ""{1}"", ""0.0.0.0"", 443, 1033)
    $rsConfig.CreateSSLCertificateBinding(""ReportServerWebApp"", ""{1}"", ""::"", 443, 1033)
    $rsconfig.SetServiceState($false, $false, $false)
    $rsconfig.SetServiceState($true, $true, $true)", x509.Subject.Substring(3), thumbprint.ToLower(), instanceName );

推荐阅读