Endpoint Protection

 View Only

  • 1.  SEP, SQL 2012, and Always On

    Trusted Advisor
    Posted Apr 10, 2014 04:35 PM

    I know that SEP 12 supports SQL 2012 but our DBAs are asking if SEP will support its SQL database being configured for Always On.

    Anybody know?



  • 2.  RE: SEP, SQL 2012, and Always On
    Best Answer

    Posted Apr 10, 2014 04:39 PM

    It can't natively failover between two DBs but review this article as it provides an alternative method.

    http://www.symantec.com/docs/TECH197242



  • 3.  RE: SEP, SQL 2012, and Always On

    Trusted Advisor
    Posted Apr 10, 2014 04:57 PM

    "An alternative method is that the customer uses an Availability Group Listener for SQL which will give a virtual network name (VNN), virtual IP (VIP), this VIP or VNN can be used to configure the SEPM database. The Availability Group Listener will ensure that it connects to the correct SQL database."

    This describes exactly what SQL 2012 Always On is.  Perfect!