Install the latest AlwaysOn features for ADO.NET(Matt Neerincx)

Install the latest AlwaysOn features for ADO.NET(Matt Neerincx)

  • Comments 5

Matt Neerincx from the SQL Server Data Programmability team discusses installing the
latest AlwaysOn features for ADO.NET.   Demonstrates how to install the ADO.NET updates
and use the features with SQL Server Management Studio and Visual Studio.

Click here to play this video

Leave a Comment
  • Please add 6 and 8 and type the answer here:
  • Post
  • Sorry the current video is corrupted at about 3 minutes, I'm working to get this fixed.

  • Hi folks, I fixed the video.  Note that we just released the .NET Framework 4.0.3 and I recommend you install this update versus the 4.0.2 mentioned in the video.   The .NET Framework 4.0.3 has some additional fixes for the MultiSubnetFailover feature to support connecting to clustered named instances as well as some performance improvements for failover.

  • where do you download 4.0.3 from? and do you need to install on Web servers only? is there a VS2010 also?

  • The URL is here msdn.microsoft.com/.../hh854775

    Likewise you can search by KB number, the numbers are below:

    Download the Design-time Update; for more information, see KB2600214

    Download the Run-time Update; for more information, see KB2600211

    Download the Multi-Targeting Pack; for more information, see KB2600213

  • To answer your other question:

    To update VS2010, install the Design-time update.  This enables intellisense for ApplicationIntent and MultiSubnetFailover keywords as well as 4.0.3 targeting ability for VS.NET.

    The run time update has to be installed anywhere you run code that uses the ApplicationIntent or MultiSubnetFailover keywords.   So for example if you have a Reporting Server you would need to apply this patch to the Reporting Server host to enable uploading reports that use these connection string keywords.

    Likewise, if you have an IIS web application you need to apply run time update to get IIS applications to use the keyword.

    You would also install this on your development box or any machine that you want to use SSMS to connect using these keywords.   The Design-time Update only has to be applie

Page 1 of 1 (5 items)