配置报表服务器以进行远程管理Configure a Report Server for Remote Administration

Reporting ServicesReporting Services中,您可以通过本地或远程方式配置报表服务器实例。In Reporting ServicesReporting Services, you can configure report server instances locally or remotely. 若要配置远程报表服务器实例,可以使用 Reporting Services 配置工具或编写使用 Reporting ServicesReporting Services Windows Management Instrumentation (WMI) 提供程序的自定义代码。To configure a remote report server instance, you can use the Reporting Services Configuration tool or write custom code that uses the Reporting ServicesReporting Services Windows Management Instrumentation (WMI) provider. Reporting Services 配置工具为 WMI 提供程序提供了一个图形界面,这样您便可以直接配置报表服务器,而不必编写代码。The Reporting Services Configuration tool provides a graphical interface to the WMI provider so that you can configure a report server without having to write code. 启动该工具时,可以指定要连接的远程服务器。When you start the tool, you can specify a remote server to connect to.

在可以使用该工具配置远程报表服务器之前,必须按照本主题中的说明在 Windows 防火墙中启用端口、启用远程连接并启用远程 WMI 请求。Before you can use the tool to configure a remote report server, you must follow the instructions in this topic to enable ports in Windows Firewall, enable remote connections, and enable remote WMI requests.

正确的配置可帮助您避免出现以下错误:Proper configuration helps you avoid the following error:

The machine could not be found.

"The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)".

先决条件Prerequisites

若要修改防火墙设置,必须从本地登录,并且您必须是本地 Administrators 组的成员。To modify firewall settings, you must be logged on locally and you must be a member of the local Administrators group. 不能通过远程连接来修改远程计算机的 Windows 防火墙设置。You cannot modify the Windows firewall settings of a remote computer over a remote connection.

如果要为非管理员用户启用远程管理,则必须为该帐户授予对分布式组件对象模型 (DCOM) 的远程激活权限。If you want to enable remote administration for a non-administrator user, you must grant the account Distributed Component Object Model (DCOM) Remote Activation permissions. 本主题提供了有关配置服务器以供非管理员访问的说明。Instructions for configuring the server for non-administrator access are provided in this topic.

某些组织的组策略阻止某些操作系统或用户进行远程服务器管理。Some organizations have group policies that prevent remote server administration for certain operating systems or users. 开始修改防火墙设置之前,请与网络管理员进行核实,以确认是否存在对远程管理的限制。Before you begin modifying firewall settings, check with your network administrator to verify whether there are restrictions on remote administration.

有关详细信息,请参阅 MSDN 上 Platform SDK 文档中的 Connecting Through Windows Firewall (通过 Windows 防火墙连接)。For more information, see Connecting Through Windows Firewall in the Platform SDK documentation on MSDN.

任务Tasks

启用远程报表服务器配置的任务包括:Tasks that enable remote report server configuration include the following:

  • 在 Windows 防火墙中启用端口以允许报表服务器和 SQL Server 数据库引擎实例所使用的端口的请求。Enable ports in Windows Firewall to allow requests on ports used by the report server and by the SQL Server Database Engine instance. 请参阅 将防火墙配置为允许报表服务器访问为数据库引擎访问配置 Windows 防火墙See Configure a Firewall for Report Server Access and Configure a Windows Firewall for Database Engine Access.

  • 启用与承载报表服务器数据库的数据库引擎实例之间的远程连接。Enable remote connections to the instance of the Database Engine instance that hosts the report server database. 远程连接是配置报表服务器数据库连接和管理加密密钥所必需的。A remote connection is necessary for configuring the report server database connection and managing the encryption keys.

  • 启用远程 WMI 请求以通过 MicrosoftMicrosoft Windows 防火墙。Enable remote WMI requests to pass through the MicrosoftMicrosoft Windows firewall.

  • 如果要配置远程报表服务器以便由非管理用户进行管理,则必须设置 DCOM 权限以启用对标准 Windows 用户帐户的远程 WMI 访问。If you are configuring a remote report server for administration by a non-administrative user, you must set DCOM permissions to enable remote WMI access to a standard Windows user account. 由于 WMI 使用 DCOM 作为远程调用传输方式,因此必须设置 DCOM 权限,以使不是以本地管理员身份登录的用户可以配置服务器。Because WMI uses DCOM as transport for remote calls, you must set the DCOM permissions so that users who are not logged on as the local administrator can configure the server.

  • 如果要配置远程报表服务器以便由非管理用户进行管理,则还必须设置对报表服务器 WMI 命名空间的 WMI 权限。If you are configuring a remote report server for administration by a non-administrative user, you must also set WMI permissions on the report server WMI namespace. 默认情况下,本地管理员组的所有成员都有权访问报表服务器 WMI 命名空间。By default, all members of the local Administrator group have access to the report server WMI namespace. 如果要对非管理员授予访问权限,则必须设置权限。If you want to grant access to non-administrators, you must set permissions.

本主题中提供了有关如何执行这些任务的说明。Instructions on how to perform these tasks are provided in this topic.

配置与报表服务器数据库的远程连接To configure remote connections to the report server database

  1. 单击 “开始” ,依次指向 “程序”Microsoft SQL ServerMicrosoft SQL Server“配置工具” ,然后单击 “SQL Server 配置管理器”Click Start, point to Programs, point to Microsoft SQL ServerMicrosoft SQL Server, point to Configuration Tools, and click SQL Server Configuration Manager.

  2. 在左窗格中,展开“SQL Server 网络配置”,然后针对 SQL ServerSQL Server 实例单击“协议” 。In the left pane, expand SQL Server Network Configuration, and then click Protocols for the instance of SQL ServerSQL Server.

  3. 在详细信息窗格中,启用“TCP/IP”和“命名管道”协议,然后重启 SQL ServerSQL Server 服务。In the details pane, enable the TCP/IP and Named Pipes protocols, and then restart the SQL ServerSQL Server service.

在 Windows 防火墙中启用远程管理To enable remote administration in Windows Firewall

  1. 以本地管理员身份登录要启用远程管理功能的计算机。Log on as a local administrator to the computer for which you want to enable remote administration.

  2. 使用管理员权限打开命令提示符。Open a command prompt with administrative privileges.

  3. 运行以下命令:Run the following command:

    netsh.exe firewall set service type=REMOTEADMIN mode=ENABLE scope=ALL  
    

    可以指定不同的作用域选项。You can specify different options for Scope. 有关详细信息,请参阅 Windows 防火墙产品文档。For more information, see the Windows Firewall product documentation.

  4. 验证是否已启用远程管理。Verify that remote administration is enabled. 可以运行以下命令以显示状态:You can run the following command to show the status:

    netsh.exe firewall show state  
    
  5. 重新启动计算机。Reboot the computer.

设置 DCOM 权限为非管理员启用远程 WMI 访问To set DCOM permissions to enable remote WMI access for non-administrators

  1. 在“开始”菜单中,指向 “管理工具” ,单击 “组件服务”On the Start menu, point to Administrative Tools, click Component Services.

    对于 Windows Vista,在“开始”菜单上依次单击 “所有程序”“运行” ,然后输入 mmc comexp.mscFor Windows Vista, on the Start menu, click All Programs, click Run, and then enter mmc comexp.msc.

  2. 打开“组件服务”文件夹。Open the Component Services folder.

  3. 打开“计算机”文件夹。Open the Computers folder.

  4. 选择“我的电脑”。Select My Computer.

  5. “操作” 菜单中,选择 “属性”On the Action menu, and select Properties.

  6. 单击 “COM 安全”Click COM Security.

  7. “启动和激活权限” 中单击 “编辑限制”In Launch and Activation Permissions, click Edit Limits.

  8. 如果在 “启动权限” 中没有看到您的名称,请单击 “添加”If you do not see your name in Launch Permission, click Add.

  9. 键入您的用户帐户名,然后单击 “确定”Type the name of your user account, and then click OK.

  10. 在“<User or Group> 权限”的“允许”列中,选择“远程启动”和“远程激活”,然后单击“确定” 。In Permissions for <User or Group>, in the Allow column, select Remote Launch and Remote Activation, and then click OK.

为非管理员设置报表服务器 WMI 命名空间的权限To set permissions on the report server WMI namespace for non-administrators

  1. 在“开始”菜单中,指向 “管理工具” ,单击 “计算机管理”On the Start menu, point to Administrative Tools, click Computer Management.

  2. 打开“服务和应用程序”文件夹。Open the Services and Applications folder.

  3. 右键单击“WMI 控件”,然后选择“属性” 。Right-click WMI Control, and select Properties.

  4. 单击 “安全性”Click Security.

  5. 打开 Root 文件夹。Open the Root folder.

  6. 打开 Microsoft 文件夹。Open the Microsoft folder.

  7. 打开 SQLServer 文件夹。Open the SQLServer folder.

  8. 打开 ReportServer 文件夹。Open the ReportServer folder.

  9. 打开实例文件夹。Open instance folder. 如果安装了默认实例,则文件夹为 MSSQLSERVER。If you installed the default instance, the folder is MSSQLSERVER.

  10. 打开 v10 文件夹。Open the v10 folder.

  11. 选中 Admin 文件夹,然后单击 “安全性”Select the Admin folder, and then click Security.

  12. 单击 “添加” ,然后键入将用于管理服务器的用户帐户。Click Add, and then type the user account you will use to manage the server.

  13. “允许” 列中,选择 “启用帐户”“远程启用”“读取安全” ,然后单击 “确定”In the Allow column, select Enable Account, Remote Enable, and Read Security, and then click OK.

另请参阅See Also

报表服务器配置管理器(本机模式)Report Server Configuration Manager (Native Mode)