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):
-
ApplicationIntentWhen 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 RoutingRead-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.
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 system |
Update |
|---|---|
|
All supported x86-based versions of Windows XP SP3 |
|
|
All supported x64-based versions of Windows XP SP3 |
|
|
All supported IA-64-based versions of Windows XP SP3 |
|
|
All supported x86-based versions of Windows Server 2008 SP2 |
|
|
All supported x64-based versions of Windows Server 2008 SP2 |
|
|
All supported IA-64-based versions of Windows Server 2008 SP2 |
|
|
All supported x86-based versions of Windows Server 2008 R2 SP1 |
|
|
All supported x64-based versions of Windows Server 2008 R2 SP1 |
|
|
All supported IA-64-based versions of Windows Server 2008 R2 SP1 |
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 servicesMicrosoft 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.
For all supported x86-based versions of Windows XP SP3
|
File name |
File version |
File size |
Date |
Time |
Platform |
|---|---|---|---|---|---|
|
System.data.dll |
2.0.50727.5713 |
2,972,672 |
23-Jan-2012 |
07:33 |
x86 |
For all supported x64-based versions of Windows XP SP3
|
File name |
File version |
File size |
Date |
Time |
Platform |
|---|---|---|---|---|---|
|
System.data.dll |
2.0.50727.5713 |
3,145,216 |
22-Jan-2012 |
23:15 |
x64 |
|
System.data.dll |
2.0.50727.5713 |
2,972,672 |
23-Jan-2012 |
07:33 |
x86 |
For all supported IA-64-based versions of Windows XP SP3
|
File name |
File version |
File size |
Date |
Time |
Platform |
|---|---|---|---|---|---|
|
System.data.dll |
2.0.50727.5713 |
3,301,888 |
22-Jan-2012 |
23:29 |
IA-64 |
|
System.data.dll |
2.0.50727.5713 |
2,972,672 |
23-Jan-2012 |
07:33 |
x86 |
For all supported x86-based versions of Windows Server 2008 SP2
|
File name |
File version |
File size |
Date |
Time |
Platform |
|---|---|---|---|---|---|
|
System.data.dll |
2.0.50727.5730 |
2,972,672 |
08-May-2012 |
10:58 |
x86 |
For all supported x64-based versions of Windows Server 2008 SP2
|
File name |
File version |
File size |
Date |
Time |
Platform |
|---|---|---|---|---|---|
|
System.data.dll |
2.0.50727.5730 |
3,145,216 |
08-May-2012 |
10:58 |
x64 |
|
System.data.dll |
2.0.50727.5730 |
2,972,672 |
08-May-2012 |
10:58 |
x86 |
For all supported IA-64-based versions of Windows Server 2008 SP2
|
File name |
File version |
File size |
Date |
Time |
Platform |
|---|---|---|---|---|---|
|
System.data.dll |
2.0.50727.5730 |
3,301,888 |
08-May-2012 |
10:51 |
IA-64 |
|
System.data.dll |
2.0.50727.5730 |
2,972,672 |
08-May-2012 |
10:58 |
x86 |
For all supported x86-based versions of Windows Server 2008 R2 SP1
|
File name |
File version |
File size |
Date |
Time |
Platform |
|---|---|---|---|---|---|
|
System.data.dll |
2.0.50727.5718 |
2,972,672 |
30-Jan-2012 |
23:34 |
x86 |
For all supported x64-based versions of Windows Server 2008 R2 SP1
|
File name |
File version |
File size |
Date |
Time |
Platform |
|---|---|---|---|---|---|
|
System.data.dll |
2.0.50727.5718 |
3,145,216 |
30-Jan-2012 |
23:29 |
x64 |
|
System.data.dll |
2.0.50727.5718 |
2,972,672 |
30-Jan-2012 |
23:34 |
x86 |
For all supported IA-64-based versions of Windows Server 2008 R2 SP1
|
File name |
File version |
File size |
Date |
Time |
Platform |
|---|---|---|---|---|---|
|
System.data.dll |
2.0.50727.5718 |
3,301,888 |
30-Jan-2012 |
23:23 |
IA-64 |
|
System.data.dll |
2.0.50727.5718 |
2,972,672 |
30-Jan-2012 |
23:34 |
x86 |
Status
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
