SQL Server 2012 Native Client ApplicationIntent Connection String Property

[ahmerzaidi]

The latest SQL Server 2012 Native Client supports the use of an ApplicationIntent Property to work with SQL Server 2012 AlwaysOn Availability Groups.  Has anyone here succesfully been able to implement this as the UI doesn't not currently have an option to add this to the connection string?

I've also tried using the sqljdbc4 driver (JDBC connection type), manually modifing the connection string stored in the content store, and trying the "Other" connection type for both JDBC and SQL Client Client 2012.

I do have a PMR logged with IBM, but wanted to get feedback from the community.

[ahmerzaidi]

IBM has logged a defect for not having support for ApplicationIntent within the UI when configuring SQL Server 2012 Native Client.

Work around:
1. Start by configuring SQL Server 2012 Native Client as you normally would.
2. Copy the Generate Connection String
3. Modify the generated Connection String to include "Application Intent=Readonly;" (no quotes).  Place this in front of ";@COLSEQ="
4. Use the Connection Type "Other Type"
5. Paste modified connection string in Connection String text box.
6. Test and Save.

As mentioned in my above post, I tried using the "Other" connection type, but was unsuccessful because I was using "ApplicationIntent=ReadOnly" (no spaces) as documented in numerous places on MSDN.