First published on MSDN on Aug 09, 2012
Here is the an issue I saw come across an alias that is a gotcha!
I’m running into a problem connecting to an AlwaysOn read-intent secondary and I was wondering if someone could help me out. I have the .Net Framework 4.5 installed and the newest SQL Client install for SQL Server 2012. Running this command from the server where SQL Server 2012 is installed works fine:
However, as soon as I include the ApplicationIntent=ReadOnly switch, it fails. I’m not sure how to specify that the SQL Native Client 11 should be used in the connection string (and not sure if I need to do such a thing.