Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. An update introduces support for the AlwaysOn features in SQL Server 2012 or a later version to the .NET Framework 3.5 SP1

An update introduces support for the AlwaysOn features in SQL Server 2012 or a later version to the .NET Framework 3.5 SP1

View products that this article applies to.

Introduction

This update introduces support for the following AlwaysOn features in Microsoft SQL Server 2012 or a later version to the Microsoft .NET Framework 3.5 Service Pack 1 (SP1):
  • ApplicationIntent
    When the ApplicationIntent property is set to ReadOnly, the client requests a read access operation when it connects to an AlwaysOn-enabled database. The server will enforce the read-only access operation both at connection time, and during a USE database statement, but only to an AlwaysOn-enabled database. When the ApplicationIntent property is set to ReadWrite, the client requests a regular (read-write) access operation when it connects to an AlwaysOn-enabled database. The default setting for the ApplicationIntent property is ReadWrite.
  • Read-Only Routing
    Read-only routing is a feature that can guarantee the availability of a read-only replica of a database. To enable read-only routing:
    • You must connect to an Always On Availability Group availability group listener.
    • The ApplicationIntent connection string keyword must be set to ReadOnly.
    • The Availability Group must be configured by the database administrator to enable read-only routing.
  • MultiSubnetFailover (including support for the named instance)
    Always specify MultiSubnetFailover=True when you connect to an availability group listener or a failover cluster availability group listener in SQL Server 2012 or a later vesion. MultiSubnetFailover enables faster failover for all availability groups and all failover cluster instances in SQL Server 2012 or a later version, and will significantly reduce failover time for single-subnet and multi-subnet AlwaysOn topologies. During a multi-subnet failover, the client will try connections in parallel.This hotfix also includes support for AlwaysOn named instances connectivity.

    Note This hotfix does not add support for the SqlConnectionStringBuilder.ApplicationIntent property or for the SqlConnectionStringBuilder.MultiSubnetFailover property. Instead, these properties can be accessed by using the SqlConnectionStringBuilder["ApplicationIntent"] indexer and the SqlConnectionStringBuilder["MultiSubnetFailover"] indexer.

↑ Back to the top

More Information

For more information about the SQL Server AlwaysOn feature, visit the following Microsoft website:
Introducing SQL Server AlwaysOn

Update information

How to obtain this update

The following files are available for download from the Microsoft Download Center:
Operating systemUpdate
All supported x86-based versions of Windows XP SP3Download Download the update package now.
All supported x64-based versions of Windows XP SP3Download Download the update package now.
All supported IA-64-based versions of Windows XP SP3Download Download the update package now.
All supported x86-based versions of Windows Server 2008 SP2Download Download the update package now.
All supported x64-based versions of Windows Server 2008 SP2Download Download the update package now.
All supported IA-64-based versions of Windows Server 2008 SP2Download Download the update package now.
All supported x86-based versions of Windows Server 2008 R2 SP1Download Download the update package now.
All supported x64-based versions of Windows Server 2008 R2 SP1Download Download the update package now.
All supported IA-64-based versions of Windows Server 2008 R2 SP1Download Download the update package now.
Note When you install the update package, you may notice that the update package applies to the .NET Framework 2.0. This is because the code fix is in the .NET Framework 2.0 layer, which is included in the .NET Framework 3.5 SP1.

For more information about how to download Microsoft support files, click the following article number to view the article in the Microsoft Knowledge Base:
119591 How to obtain Microsoft support files from online services
Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help prevent any unauthorized changes to the file.

Prerequisites

To apply this update, you must have the .NET Framework 3.5 SP1 installed on the computer.

Registry information

To use the update in this package, you do not have to make any changes to the registry.

Restart requirement

You do not have to restart the computer after you apply this hotfix if the affected files are not being used.

Update replacement information

This update does not replace a previously released update.

File information

↑ Back to the top

The global version of this hotfix has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time item in Control Panel.
For all supported x86-based versions of Windows XP SP3
File nameFile versionFile sizeDateTimePlatform
System.data.dll2.0.50727.57132,972,67223-Jan-201207:33x86
For all supported x64-based versions of Windows XP SP3
File nameFile versionFile sizeDateTimePlatform
System.data.dll2.0.50727.57133,145,21622-Jan-201223:15x64
System.data.dll2.0.50727.57132,972,67223-Jan-201207:33x86
For all supported IA-64-based versions of Windows XP SP3
File nameFile versionFile sizeDateTimePlatform
System.data.dll2.0.50727.57133,301,88822-Jan-201223:29IA-64
System.data.dll2.0.50727.57132,972,67223-Jan-201207:33x86
For all supported x86-based versions of Windows Server 2008 SP2
File nameFile versionFile sizeDateTimePlatform
System.data.dll2.0.50727.57302,972,67208-May-201210:58x86
For all supported x64-based versions of Windows Server 2008 SP2
File nameFile versionFile sizeDateTimePlatform
System.data.dll2.0.50727.57303,145,21608-May-201210:58x64
System.data.dll2.0.50727.57302,972,67208-May-201210:58x86
For all supported IA-64-based versions of Windows Server 2008 SP2
File nameFile versionFile sizeDateTimePlatform
System.data.dll2.0.50727.57303,301,88808-May-201210:51IA-64
System.data.dll2.0.50727.57302,972,67208-May-201210:58x86
For all supported x86-based versions of Windows Server 2008 R2 SP1
File nameFile versionFile sizeDateTimePlatform
System.data.dll2.0.50727.57182,972,67230-Jan-201223:34x86
For all supported x64-based versions of Windows Server 2008 R2 SP1
File nameFile versionFile sizeDateTimePlatform
System.data.dll2.0.50727.57183,145,21630-Jan-201223:29x64
System.data.dll2.0.50727.57182,972,67230-Jan-201223:34x86
For all supported IA-64-based versions of Windows Server 2008 R2 SP1
File nameFile versionFile sizeDateTimePlatform
System.data.dll2.0.50727.57183,301,88830-Jan-201223:23IA-64
System.data.dll2.0.50727.57182,972,67230-Jan-201223:34x86

↑ Back to the top

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

↑ Back to the top

Keywords: kbqfe, kbhotfixserver, kbfix, kbhotfixdev, kbexpertiseadvanced, kbsurveynew, atdownload, kb

↑ Back to the top

Article Info
Article ID : 2654347
Revision : 3
Created on : 4/17/2018
Published on : 4/18/2018
Exists online : False
Views : 308