Select the product you need help with

An update introduces support for the AlwaysOn features from SQL Server 2012 to the .NET Framework 3.5 SP1

Article ID: 2654347 - View products that this article applies to.

Introduction

This update introduces support for the following Microsoft SQL Server 2012 AlwaysOn features 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 a SQL Server 2012 availability group listener, or to a SQL Server 2012 failover cluster availability group listener. MultiSubnetFailover enables faster failover for all availability groups and all failover cluster instances in SQL Server 2012, 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 | Give Feedback

More information

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

Introducing SQL Server AlwaysOn

(http://msdn.microsoft.com/en-us/sqlserver/gg490638)

Update information

How to obtain this update

The following files are available for download from the Microsoft Download Center:

Collapse this tableExpand this table

Operating system	Update
All supported x86-based versions of Windows XP SP3	Collapse this imageExpand this image Download the update package now. (http://go.microsoft.com/fwlink/?LinkID=248510&clcid=0x409)
All supported x64-based versions of Windows XP SP3	Collapse this imageExpand this image Download the update package now. (http://go.microsoft.com/fwlink/?LinkID=248511&clcid=0x409)
All supported IA-64-based versions of Windows XP SP3	Collapse this imageExpand this image Download the update package now. (http://go.microsoft.com/fwlink/?LinkID=248512&clcid=0x409 )
All supported x86-based versions of Windows Server 2008 SP2	Collapse this imageExpand this image Download the update package now. (http://go.microsoft.com/fwlink/?LinkID=265776&clcid=0x409)
All supported x64-based versions of Windows Server 2008 SP2	Collapse this imageExpand this image Download the update package now. (http://go.microsoft.com/fwlink/?LinkID=265777&clcid=0x409 )
All supported IA-64-based versions of Windows Server 2008 SP2	Collapse this imageExpand this image Download the update package now. (http://go.microsoft.com/fwlink/?LinkID=265778&clcid=0x409 )
All supported x86-based versions of Windows Server 2008 R2 SP1	Collapse this imageExpand this image Download the update package now. (http://go.microsoft.com/fwlink/?LinkID=265779&clcid=0x409 )
All supported x64-based versions of Windows Server 2008 R2 SP1	Collapse this imageExpand this image Download the update package now. (http://go.microsoft.com/fwlink/?LinkID=265780&clcid=0x409 )
All supported IA-64-based versions of Windows Server 2008 R2 SP1	Collapse this imageExpand this image Download the update package now. (http://go.microsoft.com/fwlink/?LinkID=265781&clcid=0x409 )

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

(http://support.microsoft.com/kb/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

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.