使用透明网络 IP 解析Using Transparent Network IP Resolution

适用于:Applies to: 是SQL ServerSQL Server(所有支持的版本)yesSQL ServerSQL Server (all supported versions) 是Azure SQL 数据库Azure SQL DatabaseYesAzure SQL 数据库Azure SQL Database 是Azure SQL 托管实例Azure SQL Managed InstanceYesAzure SQL 托管实例Azure SQL Managed Instance 是Azure Synapse AnalyticsAzure Synapse AnalyticsyesAzure Synapse AnalyticsAzure Synapse Analytics 是并行数据仓库Parallel Data Warehouseyes并行数据仓库Parallel Data Warehouse适用于:Applies to: 是SQL ServerSQL Server(所有支持的版本)yesSQL ServerSQL Server (all supported versions) 是Azure SQL 数据库Azure SQL DatabaseYesAzure SQL 数据库Azure SQL Database 是Azure SQL 托管实例Azure SQL Managed InstanceYesAzure SQL 托管实例Azure SQL Managed Instance 是Azure Synapse AnalyticsAzure Synapse AnalyticsyesAzure Synapse AnalyticsAzure Synapse Analytics 是并行数据仓库Parallel Data Warehouseyes并行数据仓库Parallel Data Warehouse

下载下载 OLE DB 驱动程序DownloadDownload OLE DB Driver

目的Purpose

透明网络 IP 解析 (TNIR) 是对现有 MultiSubnetFailover 功能的修订。Transparent Network IP Resolution (TNIR) is a revision of the existing MultiSubnetFailover feature. 如果第一个解析的主机名 IP 未响应,且存在多个与主机名关联的 IP,TNIR 就会影响驱动程序的连接序列。TNIR affects the connection sequence of the driver in the case where the first resolved IP of the hostname does not respond and there are multiple IPs associated with the hostname. TNIR 与 MultiSubnetFailover 交互,以提供下列三个连接序列:TNIR interacts with MultiSubnetFailover to provide the following three connection sequences:

  • 0:先尝试一个 IP,再并行尝试所有 IP0: One IP is attempted, followed by all IPs in parallel
  • 1:并行尝试所有 IP1: All IPs are attempted in parallel
  • 2:逐一尝试所有 IP2: All IPs are attempted one after another
TransparentNetworkIPResolutionTransparentNetworkIPResolution MultiSubnetFailoverMultiSubnetFailover 行为Behavior
TrueTrue TrueTrue 11
正确True 错误False 00
FalseFalse TrueTrue 11
FalseFalse FalseFalse 22

设置透明网络 IP 解析Setting Transparent Network IP Resolution

TransparentNetworkIPResolution 默认情况下处于启用状态。TransparentNetworkIPResolution is enabled by default. MultiSubnetFailover 默认情况下处于禁用状态。MultiSubnetFailover is disabled by default. 以下页面提供了有关设置这些属性的详细信息:The following pages provide more information about setting these properties:

另请参阅See Also

适用于 SQL Server 的 OLE DB 驱动程序对高可用性和灾难恢复的支持OLE DB Driver for SQL Server Support for High Availability, Disaster Recovery