I have a four node SQL Server 2014 (12.0.4416) environment with one node acting as a read only node. When I setup routing, I can use the applicationintent = readonly property and everything seems to work. My connections that use applicationintent readonly forward to the correct server. Confirmed by running a select @@servername.
However, when I disconnect the readonly replica from the network or reboot it, the connections now go back to reading from the primary.
Do you have to enable anything to get it working again after a reboot?
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire