Please note that this article discusses the setup for Azure SQL databases - not an MS SQL Server running in Azure. To configure an MS SQL database server running in Azure, please refer to the Configuring Microsoft SQL Server documentation.
To configure the Azure SQL database, perform the following steps.
Step 1. Create a database user
PaperCut NG/MF requires a user to connect to the database. Ensure that you have a database user set up in the Azure SQL database that has:
- full permissions to create/drop tables
- full access to any created tables.
This user will often be created by the Azure SQL administrator when the Azure SQL database is created.
Step 2. Configure the database driver
- For brand new installations of PaperCut NG/MF version 25.0 and later, you will need to configure the MS JDBC driver. For more information and steps, see Installing or upgrading the Microsoft SQL JDBC driver (database driver).
- For upgrades of PaperCut NG/MF from previous versions (24.x or earlier), ensure that you’re using a supported Microsoft database driver. For more information and steps, see Installing or upgrading the Microsoft SQL JDBC driver (database driver).
What’s next?
If you’re migrating to the external database for the first time, continue with the steps (Step 5: Change the PaperCut NG/MF connection details) from our Upsize to an external database (RDBMS) article.
If you’ve already migrated (and changed the connection details as documented in Upsize to an external DB) and are looking to confirm that the PaperCut Application Server is pointing to the external database successfully, you can check this using the system information in the PaperCut admin interface.
Navigate to the About tab > System info > Database, and you’ll see the type of database server listed. Database: Internal indicates that the App Server is still using the Internal ‘derby’ database, whereas Database: SQLServer indicates it’s using an SQL DB Server.
Comments