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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy