Hey @Jim Bullen ,
The team was able to test and verify locally that SQL Express works for the Hyland IdP Operational database.
A couple other things to note, as this testing was focused on quickly getting a working environment. Please follow security rules as per the policies for your environment. This also was not tested under a heavy load like we would for the full version of SQL or Oracle. So while we don't forsee any issues, use at your own risk.
A few things they did during setup that might be slightly different:
- Enable SQL Server and Windows Authentication mode
- Enable TCP
- Add a SQL user login and provide privileges (public, securityadmin)
- Provide the SQL user access to the newly created DB
- Create a new schema (they used HSI) and give the SQL user account db_owner and db-securityadmin
Outside of that, it was just creating the Hyland IdP database through the Admin UI or CLI as you would normally with SQL.
May I ask why you would use SQL Express? For instance an added layer of security or separation from the OnBase database?
If you have any trouble or questions, please let me know.
