2008/03/18

[SSIS] The RPC server is unavailable

從遠端用 SQL 2005 Management Studio 連接 SSIS 服務時,遇到了 The RPC server is unavailable 問題,

 

後來發現是防火牆的問題,查到 SQL 2005 Book 的 HOW TO ,順便引用一下,也提醒一下自己

 

How to: Configure a Windows Firewall for Integration Services Access

To configure the Windows XP Firewall or Windows Server 2003 Firewall

  1. In the Control Panel, double-click Windows Firewall.

  2. In the Windows Firewall dialog box, click the Exceptions tab and then click Add Program.

  3. In the Add a Program dialog box, click Browse, navigate to the Program Files\Microsoft SQL Server\90\DTS\Binn folder, click MsDtsSrvr.exe, and then click Open. Click OK to close the Add a Program dialog box.

  4. On the Exceptions tab, click Add Port.

  5. In the Add a Port dialog box, type RPC(TCP/135) or another descriptive name in the Name box, type 135 in the Port Number box, and then select TCP.

    Important:

    Integration Services service always uses port 135. You cannot specify a different port.

  6. In the Add a Port dialog box, you can optionally click Change Scope to modify the default scope.

  7. In the Change Scope dialog box, select My network (subnet only) or type a custom list, and then click OK.

  8. To close the Add a Port dialog box, click OK.

  9. To close the Windows Firewall dialog box, click OK.

http://msdn2.microsoft.com/en-us/library/ms141198.aspx

沒有留言: