March 13, 2018 at 2:17 pm
I've been working on setting up a development environment to test out Always On Availability Groups. I have everything setup and one database is synchronized. I noticed today when connecting to the Listener in SSMS that I still have access to the non-synchronized databases and I'm able to query data. I was not expecting to have access to those databases on the Listener. Do I have something setup wrong?
March 14, 2018 at 5:20 am
Samwell - Tuesday, March 13, 2018 2:17 PMI've been working on setting up a development environment to test out Always On Availability Groups. I have everything setup and one database is synchronized. I noticed today when connecting to the Listener in SSMS that I still have access to the non-synchronized databases and I'm able to query data. I was not expecting to have access to those databases on the Listener. Do I have something setup wrong?
When you connect to Listener you are connecting to Primary Server where you Availability Group databases are in R\W mode. You can still access other databases on that server through listener.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply