Updated: 09 April 2022

Clustered SQL Servers is NOT the same thing as Always On availability - c06900908

Clustered SQL Servers is NOT the same thing as Always On availability.

Always On is a specific deployment configuration that we do not state official support for (although PrinterOn expects it will work f)

  • JDBC driver is being updated in version in 4.1.3
  • The new JDBC driver from Microsoft claims to support Always On Availability
  • Have confirmed that it will work by manually updating the JDBC driver in older versions as well
  • PrinterOn supports Single SQL Server and Clustered SQL servers
  • 'Clusters' DOES NOT EQUAL 'Always On' though
  • There are three deployment scenario's :
    1. SQL is on the same server as the PON software
    2. SQL is on a separate server
    3. SQL is on separate servers configured in a high availability mode

All 3 of these are tested as part of our standard development and test process, but this does not automatically mean that because we testing a clustered environment that Always On Availability is supported.

Always On Availability is a customer specific deployment of their SQL Server DB environment that is not officially documented as being supported by PrinterOn , but also does not appear to require any additional development to complete, only validation in the customer environment.