How do I use SSL with Microsoft SQL Server?
Contents
By default PaperCut uses an internal embedded database called Apache Derby which was initially developed by IBM and sold as Cloudspace DB. PaperCut can also be run on external databases like Microsoft SQL Server.
Some PaperCut customers may wish to utilize a SSL connection to their Microsoft SQL server. When making the changes as described in the manual at the end of this document, you will need to make an additional change to support SSL connection.
Original
#database.url=jdbc:jtds:sqlserver://localhost/papercut
Modified
#database.url=jdbc:jtds:sqlserver://localhost/papercut;ssl=required
Additional steps for 14.2 onwards
With the release of 14.2 we updated the version of Java PaperCut uses, in this updated Java engine some SSL connection issues were discovered between the Java database driver and MS SQL Server. When using the ssl=required
modification above, you may receive errors connecting to the database, in these circumstances we recommend the additional configuration steps:
- Create a text file in the directory:
[app-path]\server\custom\
named service.conf - Open the file in a text editor and add the following line:
wrapper.java.additional.7=-Djsse.enableCBCProtection=false
- Save the text file.
- Restart the PaperCut Application Server service.
- Test the connection.
For more information using an external database, and instructions on how to “upsize” to an external database, see the manual here.
Other Microsoft SQL Server connection options
PaperCut utilizes the jTDS JDBC driver which has other connection options that may be applicable to your environment.
Categories: How-to Articles , Databases , Security and Privacy
Keywords: MSSQL , ms-sql , database server , error connecting to the SQLServer database ,
Last updated February 15, 2024
Comments