I have sql server always on configured, There is one primary server(p1) and two secondary server.(S1 & S2)
One secondary server database is read only(S1) and other secondary server is not accessible for any read (S2).
Now if i want to make S2 as read only and other S1 as not accessible.Can you pls tell me what configuration i should change in order to change this .
Thanks in advance.