Prerequisites for Using the AlwaysOn Availability Groups Feature

  • All the Server Login accounts must be replicated across all the primary and secondary nodes of the Microsoft SQL Servers which are configured for availability group. Although this is not provided out of the box by Microsoft, there are MSDN articles on how to achieve it.   

  • Only the user databases that are in the availability databases of the availability group must be part of the databases managed by the Microsoft SQL Server application.

Note
The Microsoft SQL Connector currently does not support the ability to read from secondary databases that are available for read-only access.