在装完sql server 2014后,ssrs 2012打不开,搜索网上好多人遇到解决方法了了。

Reporting services configuration manager创建ReportServer数据库失败

System.Runtime.InteropServices.COMException (0x800706B3): The RPC server is not listening. (Exception from HRESULT: 0x800706B3)

eerror msg:

Microsoft.ReportingServices.WmiProvider.WMIProviderException: An error occurred when attempting to connect to the report server remote procedure call (RPC) end point. Verify that the Report Server Windows service is running, and then retry the operation.

 ---> System.Runtime.InteropServices.COMException (0x800706B3): The RPC server is not listening. (Exception from HRESULT: 0x800706B3)
   --- End of inner exception stack trace ---
   at Microsoft.ReportingServices.WmiProvider.RSWmiAdmin.ThrowOnError(ManagementBaseObject mo)
   at Microsoft.ReportingServices.WmiProvider.RSWmiAdmin.GenerateDatabaseScript(String databaseName, Int32 lcid, Boolean isSharePointIntegrated, String& script)
   at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.GenerateDatabaseScript(String databaseName, Int32 lcid, Boolean isSharePointIntegrated, String& script)

  

解决办法

方法一:完全卸装

方法二:修改文件

https://arcanecode.com/2015/01/28/ssrs-2012-report-manager-cant-load-microsoft-reportingservices-sharepoint-objectmodel/

用powershell打开以下找到的四个.config 文件, 把12改成11

cls
$open="C:\Program Files (x86)\Notepad++\notepad++.exe"

cd 'C:\Windows\assembly\GAC_MSIL\Policy.11.0.Microsoft.ReportingServices.SharePoint.ObjectModel'
Get-ChildItem  *.config -Recurse|%{&$open $_.FullName}
cd 'C:\Windows\assembly\GAC_MSIL\Policy.11.0.Microsoft.ReportingServices.SharePoint.Server'
Get-ChildItem  *.config -Recurse|%{&$open $_.FullName}
cd 'C:\Windows\assembly\GAC_MSIL\Policy.11.0.Microsoft.ReportingServices.SharePoint12.Server'
Get-ChildItem  *.config -Recurse|%{&$open $_.FullName}
cd 'C:\Windows\assembly\GAC_MSIL\Policy.11.0.Microsoft.ReportingServices.SharePoint14.Server'
Get-ChildItem  *.config -Recurse|%{&$open $_.FullName}

例如把

C:\Windows\assembly\GAC_MSIL\Policy.11.0.Microsoft.ReportingServices.SharePoint.ObjectModel\12.0.0.0__89845dcd8080cc91\Policy.11.0.Microsoft.ReportingServices.SharePoint.ObjectModel.dll.config

<?xml version="1.0" encoding="ISO-8859-1"?>
<configuration>
  <runtime>
    <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
      <dependentAssembly>
        <assemblyIdentity publicKeyToken="89845dcd8080cc91" name="Microsoft.ReportingServices.SharePoint14.Server" culture="neutral"></assemblyIdentity>
        <bindingRedirect oldVersion="11.0.0.0" newVersion="12.0.0.0"></bindingRedirect>
      </dependentAssembly>
    </assemblyBinding>
  </runtime>
</configuration>

改成

<?xml version="1.0" encoding="ISO-8859-1"?>
<configuration>
  <runtime>
    <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
      <dependentAssembly>
        <assemblyIdentity publicKeyToken="89845dcd8080cc91" name="Microsoft.ReportingServices.SharePoint14.Server" culture="neutral"></assemblyIdentity>
        <bindingRedirect oldVersion="11.0.0.0" newVersion="11.0.0.0"></bindingRedirect>
      </dependentAssembly>
    </assemblyBinding>
  </runtime>
</configuration>

四个文件修改保存后,重启SSRS

DONE.

posted on 2016-04-28 09:49  PatrickWong  阅读(1370)  评论(0编辑  收藏  举报