Read/write connection redirection is available on any operating system platform. It allows client application connections to be directed to the primary replica regardless of the target server specified in the connections string. For example, the connection string can target a secondary replica. GeoPITS brings you the comprehensive details of Automatic read write connection re-routing's support in different versions & editions of SQL Server.
Version | Enterprise | Standard | Web | Express (Adv.) | Express |
---|---|---|---|---|---|
Version v2019 | Yes | ||||
Version v2017 | |||||
Version v2016 | |||||
Version v2014 | Yes | ||||
Version v2012 |
Read/write connection redirection is available on any operating system platform. It allows client application connections to be directed to the primary replica regardless of the target server specified in the connections string. For example, the connection string can target a secondary replica
You can find more details about this version here