July 6, 2026 at 4:05 pm
Hello, I would like to ask whether it is technically possible to redirect a specific list of client machines by forcing their SSMS to automatically use the ApplicationIntent=ReadOnly option when connecting to SQL Server.
The goal is to apply this behavior through an Active Directory Group Policy (GPO), ensuring that all SQL connections initiated from these machines are consistently routed to the read-only replicas.
Could you please confirm whether such a configuration can be implemented via GPO, and if so, what methods or prerequisites would be required?
Thank you in advance for your assistance. Kind regards.
July 7, 2026 at 4:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
July 7, 2026 at 7:51 pm
I don't believe so. You might be able to force specific entries are set a certain way, but I don't think you can edit an entry, as you're asking.
If these are registered servers, they are in an XML files. Others are in a binary file.
July 10, 2026 at 8:33 am
I don't think this can be done with gpo's like only for ssms . That's more for logon triggers or the network team
July 10, 2026 at 10:26 am
As far as I know, this isn't possible using Group Policy alone. The read-only option needs to be set when creating the SQL Server connection. Group Policy can help deploy settings or scripts, but it can't automatically force all SSMS connections to use the read-only mode.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply