Prerequisites
The High Availability module of Passwordstate has the following prerequisites:
Note: When installing the High Availability Module, you must be installing the same build as your primary production site. If you have not kept the installer for this specific build, then you must upgrade your primary site first to the latest release. You can download the latest installer from here - https://www.clickstudios.com.au/passwordstate-checksums.aspx - Please ensure you validate the published Checksum.
To upgrade your primary site, you can use any of the recommended methods in the following document - Passwordstate Upgrade Instructions
Web Server Prerequisites
- The HA Web server has the same web server system requirements as the primary install. Please refer to the document Passwordstate Installation Instructions for details
- Prior to establishing SQL Server data replication, there are two things which need to be done:
- On your Primary Instance of Passwordstate, go to the screen Administration -> License Information, and add your High Availability License key here
- On your Primary Instance of Passwordstate, go to the screen Administration -> Authorized Web Servers, and also register the host name of your High Availability web server – this is the NetBIOS name of your web server
Database Server Prerequisites
Below is some information regarding the various replication and SQL Server versions:
- Always On Availability Groups requires both servers to be SQL Server Enterprise
- Basic Availability Groups requires both servers to be SQL Server Standard or above
- Transactional replication requires the primary server (Publisher) to be at least SQL Server Standard, and the subscribing server can be SQL Server Express
Note 1: You must be using the same versions of SQL Server i.e. both must be Server 2022, or 2025, etc. And generally, the same Service Pack level is required.
Note 2: If using Transactional Replication, only an Active/Passive configuration is possible.
Note 3: Merge replication is not supported, due to the limitation of how many fields in a single table it can replicate.