Proper Security in Place for HA Options
Aside from the common infrastructure security protections that have been discussed already, there are often security breakdowns and other miscues directly associated with the major high availability options. As you will see, each HA option has its own set of problems and areas to consider from a security point of view. A good example of possible security miscues is not specifying the correct startup service account (Windows login/domain account) for the SQL Agent that is needed to distribute transactions for data replication. This section will highlight and re-enforce these types of issues and considerations so that you can head them off before you attempt to build any one of these complete HA options. ...
Get Microsoft® SQL Server High Availability now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
