SSRS 2019恢复ReportServer数据库后创建数据源报错

问题描述 #

已安装最新版SSRS 2019，从开发服务器恢复了ReportServer与ReportServerTempDB数据库，系统采用自定义安全配置（通过自有Cookie进行访问验证），其他功能均正常，但创建SSRS数据源时出现异常：点击「+新建」>「数据源」下拉选项后，页面弹出**「出错了，请稍后重试」**提示。

错误详情 #

通过浏览器控制台定位到，错误源于调用以下两个API接口：

• https://localhost/Reports/api/v2.0/Extensions?$filter=ExtensionType+eq+(cast(%27Data%27,%20%27Model.ExtensionType%27))
• https://localhost/Reports/api/v2.0/Extensions

两个接口均返回无具体信息的错误响应：

{
  "error":{
    "code":"0","message":""
  }
}

正常服务器参考响应 #

在功能正常的服务器上，调用https://servername/Reports/api/v2.0/Extensions可返回包含各类扩展的有效JSON响应，示例如下：

{
"@odata.context":"https://(devservername)/Reports/api/v2.0/$metadata#Extensions","value":[
    {
      "ExtensionType":"Data","Name":"SQL","LocalizedName":"Microsoft SQL Server","Visible":true,"Parameters":[
        
      ]
    },{
      "ExtensionType":"Data","Name":"SQLAZURE","LocalizedName":"Microsoft Azure SQL Database","Visible":true,"Parameters":[
        
      ]
    },{
      "ExtensionType":"Data","Name":"OLEDB-MD","LocalizedName":"Microsoft SQL Server Analysis Services","Visible":true,"Parameters":[
        
      ]
    },{
      "ExtensionType":"Data","Name":"SHAREPOINTLIST","LocalizedName":"Microsoft SharePoint List","Visible":true,"Parameters":[
        
      ]
    },{
      "ExtensionType":"Data","Name":"ESSBASE","LocalizedName":"Oracle Essbase","Visible":true,"Parameters":[
        
      ]
    },{
      "ExtensionType":"Data","Name":"SAPBW","LocalizedName":"SAP BW","Visible":true,"Parameters":[
        
      ]
    },{
      "ExtensionType":"Data","Name":"OLEDB","LocalizedName":"OLE DB","Visible":true,"Parameters":[
        
      ]
    },{
      "ExtensionType":"Data","Name":"ODBC","LocalizedName":"ODBC","Visible":true,"Parameters":[
        
      ]
    },{
      "ExtensionType":"Data","Name":"XML","LocalizedName":"XML","Visible":true,"Parameters":[
        
      ]
    },{
      "ExtensionType":"Data","Name":"ENTERDATA","LocalizedName":"手动输入数据","Visible":true,"Parameters":[
        
      ]
    },{
      "@odata.type":"#Model.DeliveryExtension","ExtensionType":"Delivery","Name":"Report Server FileShare","LocalizedName":"Windows 文件共享","Visible":true,"Parameters":[
        
      ],"IsImmutable":false,"DefaultDeliveryExtension":false
    },{
      "@odata.type":"#Model.DeliveryExtension","ExtensionType":"Delivery","Name":"NULL","LocalizedName":"空传递提供程序","Visible":true,"Parameters":[
        
      ],"IsImmutable":false,"DefaultDeliveryExtension":false
    },{
      "ExtensionType":"Render","Name":"RPL","LocalizedName":"RPL 渲染器","Visible":false,"Parameters":[
        
      ]
    },{
      "ExtensionType":"Render","Name":"HTML5","LocalizedName":"HTML5","Visible":false,"Parameters":[
        
      ]
    },{
      "ExtensionType":"Render","Name":"HTML4.0","LocalizedName":"HTML 4.0","Visible":false,"Parameters":[
        
      ]
    },{
      "ExtensionType":"Render","Name":"RGDI","LocalizedName":"远程GDI+文件","Visible":false,"Parameters":[
        
      ]
    },{
      "ExtensionType":"Render","Name":"NULL","LocalizedName":"空渲染器","Visible":false,"Parameters":[
        
      ]
    },{
      "ExtensionType":"Render","Name":"ATOM","LocalizedName":"数据馈送","Visible":true,"Parameters":[
        
      ]
    },{
      "ExtensionType":"Render","Name":"XML","LocalizedName":"含报表数据的XML文件","Visible":true,"Parameters":[
        
      ]
    },{
      "ExtensionType":"Render","Name":"CSV","LocalizedName":"CSV（逗号分隔）","Visible":true,"Parameters":[
        
      ]
    },{
      "ExtensionType":"Render","Name":"MHTML","LocalizedName":"MHTML（Web存档）","Visible":true,"Parameters":[
        
      ]
    },{
      "ExtensionType":"Render","Name":"IMAGE","LocalizedName":"TIFF文件","Visible":true,"Parameters":[
        
      ]
    },{
      "ExtensionType":"Render","Name":"PDF","LocalizedName":"PDF","Visible":true,"Parameters":[
        
      ]
    },{
      "ExtensionType":"Render","Name":"PPTX","LocalizedName":"PowerPoint","Visible":true,"Parameters":[
        
      ]
    },{
      "ExtensionType":"Render","Name":"EXCEL","LocalizedName":"Excel 2003","Visible":false,"Parameters":[
        
      ]
    },{
      "ExtensionType":"Render","Name":"EXCELOPENXML","LocalizedName":"Excel","Visible":true,"Parameters":[
        
      ]
    },{
      "ExtensionType":"Render","Name":"WORD","LocalizedName":"Word 2003","Visible":false,"Parameters":[
        
      ]
    },{
      "ExtensionType":"Render","Name":"WORDOPENXML","LocalizedName":"Word","Visible":true,"Parameters":[
        
      ]
    },{
      "@odata.type":"#Model.DeliveryExtension","ExtensionType":"DeliveryUI","Name":"Report Server FileShare","LocalizedName":"Windows 文件共享","Visible":true,"Parameters":[
        
      ],"IsImmutable":false,"DefaultDeliveryExtension":false
    }
  ]
}

排查建议 #

• 验证自定义权限配置：确认当前Cookie对应的用户账号拥有查看报表服务器扩展的权限，可通过SSRS配置管理器或ReportServer数据库的Users、Permissions表核对权限设置。
• 检查数据库恢复完整性：对比正常服务器的ReportServer.dbo.Extension表数据，确保恢复后的表中所有数据扩展（如SQL、ODBC等）的记录完整未丢失。
• 确认SSRS服务账户权限：确保SSRS服务运行账户对ReportServer数据库拥有读取权限，尤其是Extension表的访问权限。
• 重置扩展配置：尝试在SSRS配置管理器中重新注册数据扩展，或使用rsconfig.exe工具重置相关配置项。
• 查看SSRS日志：检查SSRS安装目录下的日志文件（默认路径C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\LogFiles），查找API调用失败的具体异常信息，日志中会包含更详细的错误堆栈。

内容的提问来源于stack exchange，提问作者Martin Dye