使用 SSIS 集成运行时中的“诊断连接”功能Use the diagnose connectivity feature in the SSIS integration runtime

适用于:是 Azure 数据工厂否 Azure Synapse Analytics(预览版)APPLIES TO: yesAzure Data Factory noAzure Synapse Analytics (Preview)

在执行 SSIS 基础运行时中的 SQL Server Integration Services (SSIS) 包时,可能会遇到连接问题。You might find connectivity problems while executing SQL Server Integration Services (SSIS) packages in the SSIS integration runtime. 如果 SSIS 集成运行时加入 Azure 虚拟网络,尤其会发生这些问题。These problems occur especially if your SSIS integration runtime joins the Azure virtual network.

排查连接问题时,请使用“诊断连接”功能来测试连接。Troubleshoot connectivity problems by using the diagnose connectivity feature to test connections. 此功能位于 Azure 数据工厂门户的“监视 SSIS 集成运行时”页面上。The feature is located on the monitoring SSIS integration runtime page of the Azure Data Factory portal.

“监视”页面 - 诊断连接

“监视”页面 - 测试连接

使用以下部分来了解在测试连接时出现的最常见错误。Use the following sections to learn about the most common errors that occur when you're testing connections. 每部分都介绍了以下内容:Each section describes the:

  • 错误代码Error code
  • 错误消息Error message
  • 错误的可能原因Potential cause(s) of the error
  • 建议的解决方案Recommended solution(s)

错误代码:InvalidInputError code: InvalidInput

  • 错误消息:“请验证你的输入是否正确。”Error message: "Please verify your input is correct."
  • 可能原因:输入不正确。Potential cause: Your input is incorrect.
  • 建议:请检查输入。Recommendation: Check your input.

错误代码:FirewallOrNetworkIssueError code: FirewallOrNetworkIssue

  • 错误消息:“请验证此端口在防火墙/服务器/NSG 上是否是打开的,且网络是否稳定。”Error message: "Please verify that this port is open on your firewall/server/NSG and the network is stable."
  • 可能的原因:Potential causes:
    • 服务器未打开此端口。Your server doesn't open the port.
    • 你的网络安全组拒绝了此端口上的出站流量。Your network security group is denied outbound traffic on the port.
    • 你的 NVA/Azure 防火墙/本地防火墙未打开此端口。Your NVA/Azure Firewall/on-premises firewall doesn't open the port.
  • 建议:Recommendations:
    • 打开服务器上的此端口。Open the port on the server.
    • 更新网络安全组以允许此端口上的出站流量。Update the network security group to allow outbound traffic on the port.
    • 打开 NVA/Azure 防火墙/本地防火墙上的此端口。Open the port on the NVA/Azure Firewall/on-premises firewall.

错误代码:MisconfiguredDnsSettingsError code: MisconfiguredDnsSettings

  • 错误消息:“若要在由 Azure-SSIS IR 联接的 VNet 中使用你自己的 DNS 服务器,请验证它能否解析你的主机名。”Error message: "If you're using your own DNS server in the VNet joined by your Azure-SSIS IR, verify that it can resolve your host name."
  • 可能的原因:Potential causes:
    • 你的自定义 DNS 存在问题。There's a problem with your custom DNS.
    • 你没有为专用主机名使用完全限定的域名 (FQDN)。You aren't using a fully qualified domain name (FQDN) for your private host name.
  • 建议:Recommendations:
    • 解决自定义 DNS 的问题,确保它能够解析主机名。Fix your custom DNS problem to make sure it can resolve the host name.
    • 使用 FQDN。Use the FQDN. Azure-SSIS IR 不会自动追加你自己的 DNS 后缀。Azure-SSIS IR won't automatically append your own DNS suffix. 例如,请使用 <your_private_server>.contoso.com 而非 <your_private_server>For example, use <your_private_server>.contoso.com instead of <your_private_server>.

错误代码:ServerNotAllowRemoteConnectionError code: ServerNotAllowRemoteConnection

  • 错误消息:“请验证服务器是否允许通过此端口进行远程 TCP 连接。”Error message: "Please verify that your server allows remote TCP connections through this port."
  • 可能的原因:Potential causes:
    • 你的服务器防火墙不允许远程 TCP 连接。Your server firewall doesn't allow remote TCP connections.
    • 你的服务器未联机。Your server isn't online.
  • 建议:Recommendations:
    • 在服务器防火墙上允许远程 TCP 连接。Allow remote TCP connections on the server firewall.
    • 启动服务器。Start the server.

错误代码:MisconfiguredNsgSettingsError code: MisconfiguredNsgSettings

  • 错误消息:“请验证 VNet 的 NSG 是否允许出站流量通过此端口。Error message: "Please verify that the NSG of your VNet allows outbound traffic through this port. 如果使用的是 Azure ExpressRoute 和/或 UDR,请验证是否在防火墙/服务器上打开了此端口。”If you’re using Azure ExpressRoute and or a UDR, please verify that this port is open on your firewall/server."
  • 可能的原因:Potential causes:
    • 你的网络安全组拒绝了此端口上的出站流量。Your network security group is denied outbound traffic on the port.
    • 你的 NVA/Azure 防火墙/本地防火墙未打开此端口。Your NVA/Azure Firewall/on-premises firewall doesn't open the port.
  • 建议:Recommendation:
    • 更新网络安全组以允许此端口上的出站流量。Update the network security group to allow outbound traffic on the port.
    • 打开 NVA/Azure 防火墙/本地防火墙上的此端口。Open the port on the NVA/Azure Firewall/on-premises firewall.

错误代码:GenericIssuesError code: GenericIssues

  • 错误消息:“测试连接失败,因为出现一般性错误。”Error message: "Test connection failed due to generic issues."
  • 可能原因:测试连接遇到一般性的临时问题。Potential cause: The test connection encountered a general temporary problem.
  • 建议:稍后重试测试连接。Recommendation: Retry the test connection later. 如果重试不起作用,请联系 Azure 数据工厂支持团队。If retrying doesn't help, contact the Azure Data Factory support team.

错误代码:PSPingExecutionTimeoutError code: PSPingExecutionTimeout

  • 错误消息:“测试连接超时,请稍后重试。”Error message: "Test connection timeout, please try again later."
  • 可能原因:测试连接超时。Potential cause: Test connectivity timed out.
  • 建议:稍后重试测试连接。Recommendation: Retry the test connection later. 如果重试不起作用,请联系 Azure 数据工厂支持团队。If retrying doesn't help, contact the Azure Data Factory support team.

错误代码:NetworkInstableError code: NetworkInstable

  • 错误消息:“测试连接不定期成功,因为网络不稳定。”Error message: "Test connection irregularly succeeded due to network instability."
  • 可能原因:暂时性的网络问题。Potential cause: Transient network issue.
  • 建议:检查服务器或防火墙网络是否稳定。Recommendation: Check whether the server or firewall network is stable.

后续步骤Next steps