Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

ReadOnly intent through SSMS Expand / Collapse
Author
Message
Posted Tuesday, March 26, 2013 12:00 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, July 24, 2014 5:23 PM
Points: 98, Visits: 1,135
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?
Post #1435272
Posted Wednesday, March 27, 2013 4:55 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, July 24, 2014 5:23 PM
Points: 98, Visits: 1,135
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?
Post #1435824
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse