Knowledge Base
Home » Main » How do I use SSL with Microsoft SQL Server?

How do I use SSL with Microsoft SQL Server?

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

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: Databases

keywords: MSSQL, ms-sql, database server, error connecting to the SQLServer database

Page last modified on January 18, 2011, at 07:01 PM

Comments

Share your findings and experience with other PaperCut users. Feel free to add comments and suggestions about this Knowledge Base article. Please don't use this for support requests.