March 26, 2013 at 12:00 am
I know that you have to specify ;ApplicationIntent=ReadOnly when you want to connect to a read-only replica in an availability group through SSMS, but I wondered if there was a way to configure this somehow so you didn't have to remember it every time?
Unfortunately you don't get the connection properties box when registering a server so I'm not sure if this is possible. We have some users who are complaining that they have to specify the option.
Is this possible?
March 27, 2013 at 4:55 am
I actually thought I was going to be able to get around this by making a connection to the relevant instance with the connection options, then right click and hit register.
If I look in the XML file that stores the registered servers I can see the ApplicationIntent option in the connection string but I don't get directed to the readable secondary.
Anyone experienced this and found a solution?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply