Symantec IGA

Expand all | Collapse all

SQL Always-On supported?

Jump to Best Answer
  • 1.  SQL Always-On supported?

    Posted 03-22-2018 07:01 AM

    Hi All, A customer is asking if SQL Always On is supported, and I can't find the answer. Does anyone know?

     

    Regards, Eric.



  • 2.  Re: SQL Always-On supported?

    Posted 06-04-2018 04:44 PM

    the requirements doc for 4.2 soi is clear not to use Always-on as the failover groups are not supported.

     

    Database Requirements - CA Service Operations Insight - 4.2 - CA Technologies Documentation 

     

    I would love to know when CA will update the MSSQL driver in products like PAM and SOI and take advantage of this HA solution for MSSQL



  • 3.  Re: SQL Always-On supported?
    Best Answer

    Broadcom Employee
    Posted 03-26-2018 09:19 AM

    We haven’t tested or taken advantage of anything around “always-on”.  It is a database level feature and not an application specific capability (i.e. it is a JDBC specific setting) that doesn’t require code changes.
    Our certification is for standard JDBC connectivity (without that setting enabled). It doesn’t mean it won’t work for our customers though as it seems to be RDBMS specific.