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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.