zpjx 发表于 2018-10-18 11:10:06

无法访问SQL Server Reporting Service 命名实例

  环境:Windows 2008, SQL Server 2005 Service Pack 3
  问题:在Windows 2008上,先配置为DC,然后安装SQL Server及Service Pack3。最后启动SQL Server安装程序安装命名实例QUEST。

[*]  用Http://localhost/reports$QUEST 验证Reporting Service 时出现错误: "unable to connect to the remote server".

[*]通过SQL Server Managment Stuido连接到 ***S命名实例时,出现以下错误:"No connection could be made because the target machine actively refused it :443".
[*]进入Surface Area configuration, 点击"Reporting Services"下"Windows Integrated Security" ,显示以下错误: "The request failed with HTTP status 403: Forbidden. (SQLSAC)".
  解决方案:
  问题产生的原因是在安装缺省实例后,打了SP3,而再安装命名实例时,没有打SP3.

[*]启动SQL Server Service Pack 3 安装程序,配置对命名实例的安装
[*]启动Reporting Service 配置程序,进行相关配置
[*]找到C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\rsreportserver.xml 文件,授权NETWORK SERVICES user对此文件的读和运行访问权限

页: [1]
查看完整版本: 无法访问SQL Server Reporting Service 命名实例