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.