Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
TransparentNetworkIPResolution is a revision of the existing MultiSubnetFailover feature, available starting with Microsoft ODBC Driver 13.1 for SQL Server, that 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. It interacts with MultiSubnetFailover to provide the following three connection sequences:
TransparentNetworkIPResolution | MultiSubnetFailover | Behavior |
---|---|---|
(default) | (default) | 0 |
(default) | Enabled | 1 |
(default) | Disabled | 0 |
Enabled | (default) | 0 |
Enabled | Enabled | 1 |
Enabled | Disabled | 0 |
Disabled | (default) | 2 |
Disabled | Enabled | 1 |
Disabled | Disabled | 2 |
The TransparentNetworkIPResolution
connection string and DSN keyword controls this setting at the connection-string level. The default is enabled.
Keyword | Values | Default |
---|---|---|
TransparentNetworkIPResolution |
Enabled , Disabled |
Enabled |
The SQL_COPT_SS_TNIR
pre-connection attribute allows an application to control this setting programmatically:
Connection Attribute | Size/Type | Default | Value | Description |
---|---|---|---|---|
SQL_COPT_SS_TNIR (1249) |
SQL_IS_INTEGER or SQL_IS_UINTEGER |
SQL_IS_ON (1), SQL_IS_OFF (0) |
SQL_IS_ON |
Enables or disables TNIR. |
Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayTraining
Module
Intro to Azure DNS Private Resolver - Training
learn about Azure DNS Private Resolver and how to use it to resolve DNS queries from on-premises to cloud.