none
Deploy Monitoring Server Reports wizard failed. RRS feed

  • 问题

  • hi

    Lync 环境如下:

    l  Lync Server Version: Standard

    l  1 Lync server 2010 FE server

    l  1 Monitor & Archive server

    l  1 SQL server 2008 R2(Monitor & Archive & Report are same instance)

    l  1 Edge server

    目前前端、监控&存档服务已部署完成,当我在部署 监控报表服务的时候出现如下错误

    > Deploying Monitoring Server Reports... This might take a few minutes.The Monitoring Server is using SQL instance "sql.gd.com".The data source is using SQL instance "(local)".Could not get objects from namespace root\Microsoft\SqlServer\ReportServer. Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))Cannot get the ReportServerWebService URL. Verify that Reporting Services is deployed and configured properly on the target SQL instance:"sql.gd.com", and that WMI is included on the exception list of firewall setting on the server that is running Reporting Services.Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))

    检查了连接SQL的账户lyncadmin 的权限,

      • 在master, lcscdr,qoematrics的数据库里都有owner 权限,
      • lyncadmin在sysadmin 组,
      • 且是本地管理员权限,
      • 是域domain admin及RTCUniversalServerAdmins

    在测试以下两个地址,均能正常打开:

    http://sql.gd.com/ReportServer 

    http://sql.gd.com/Reports/Pages/Folder.aspx

    目前找不到原因及问题所在,请高手指点一下谢谢

    2012年9月25日 7:17

答案

  • 如果是reporting service访问的问题,我建议你不用浪费时间。直接重新配置一下reporting service。把原先的reporting service的数据表删了,新建一下,并且在reporting service里重新配置一下。

    2012年10月11日 15:56
    版主