How do I use SSL with Microsoft SQL Server?

KB Home   |   How do I use SSL with Microsoft SQL Server?

Main.UseSSLWithMicrosoftSQLServer History

Hide minor edits - Show changes to output

Changed line 13 from:
[[#msqsql142]]
to:
[[#mssql142]]
Added line 13:
[[#msqsql142]]
Deleted line 14:
[[#msqsql142]]
Changed line 14 from:
[[#14.2]]
to:
[[#msqsql142]]
Added line 14:
[[#14.2]]
December 03, 2014, at 06:56 AM by Shane higgins -
November 27, 2014, at 06:09 AM by Shane higgins -
September 24, 2014, at 06:59 AM by 203.222.91.204 -
Added lines 13-23:
!!! 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.
#[[https://www.papercut.com/products/ng/manual/apdx-tools-start-stop-app.html | Restart the PaperCut Application Server service.]]
#Test the connection.

Changed line 32 from:
[-keywords: MSSQL, ms-sql,  database server, error connecting to the [=SQLServer=] database -]
to:
[-keywords: MSSQL, ms-sql,  database server, error connecting to the [=SQLServer=] database, -]
Deleted lines 7-10:
     [@# MS SQLServer connection example@]
    [@# IMPORTANT: The username below is a SQL Server user, not a Windows user.@]
    [@#database.type=SQLServer@]
    [@#database.driver=net.sourceforge.jtds.jdbc.Driver@]
Changed lines 9-11 from:
     [@#database.username=@]
    [@#database.password=@]

to:
Changed lines 11-20 from:
     [@# MS SQLServer connection example@]
    [@# IMPORTANT: The username below is a SQL Server user, not a Windows user.@]
    [@#database.type=SQLServer@]
    [@#database.driver=net.sourceforge.jtds.jdbc.Driver@]
    [@#database.url=jdbc:jtds:sqlserver://localhost/papercut@]''''';ssl=required'''''
    [@#database.username=@]
    [@#database.password=@]

By default, SSL connections are off, you may use either '''''requested''''' which will attempt SSL and fall back to plain text if need and '''''required''''' which will not fall back to plain text.

to:
     [@#database.url=jdbc:jtds:sqlserver://localhost/papercut;ssl=required@]
Added lines 15-18:
!!! Other Microsoft SQL Server connection options

PaperCut utilizes the jTDS JDBC driver which has [[http://jtds.sourceforge.net/faq.html#urlFormat |other connection options]] that may be applicable to your environment.

Changed line 21 from:
[-keywords: MSSQL, ms-sql, sql, ssl, database server, jtds, jtds:sqlserver, sqlserver, error connecting to the [=SQLServer=] database -]
to:
[-keywords: MSSQL, ms-sql, database server, error connecting to the [=SQLServer=] database -]
Changed lines 3-6 from:
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 above, you will need to make an additional change to support SSL connection.
to:
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.
Added lines 25-26:
By default, SSL connections are off, you may use either '''''requested''''' which will attempt SSL and fall back to plain text if need and '''''required''''' which will not fall back to plain text.
Changed lines 1-2 from:
(:title How to use SSL with Microsoft SQL Server?:)
to:
(:title How do I use SSL with Microsoft SQL Server?:)
Deleted lines 4-5:
For more information using an external database, and instructions on how to "upsize" to an external database, see the [[https://www.papercut.com/products/ng/manual/ch-ext-db.html | manual here]].
Changed lines 25-29 from:
''Categories:'' [[!Databases]]
to:
For more information using an external database, and instructions on how to "upsize" to an external database, see the [[https://www.papercut.com/products/ng/manual/ch-ext-db.html | manual here]].

''Categories:'' [[!Databases]]

[-keywords: MSSQL, ms-sql, sql, ssl, database server, jtds, jtds:sqlserver, sqlserver, error connecting to the [=SQLServer=] database -
]
Changed lines 5-6 from:
For more information using an external database, and instructions on how to "upsize" to an external database, see the [[https://www.papercut.com/products/ng/manual/ch-ext-db.html | manual here].
to:
For more information using an external database, and instructions on how to "upsize" to an external database, see the [[https://www.papercut.com/products/ng/manual/ch-ext-db.html | manual here]].
Added lines 1-27:
(:title How to 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

For more information using an external database, and instructions on how to "upsize" to an external database, see the [[https://www.papercut.com/products/ng/manual/ch-ext-db.html | manual here].

Some PaperCut customers may wish to utilize a SSL connection to their Microsoft SQL server. When making the changes as described in the manual above, you will need to make an additional change to support SSL connection.

!!! Original
    [@# MS SQLServer connection example@]
    [@# IMPORTANT: The username below is a SQL Server user, not a Windows user.@]
    [@#database.type=SQLServer@]
    [@#database.driver=net.sourceforge.jtds.jdbc.Driver@]
    [@#database.url=jdbc:jtds:sqlserver://localhost/papercut@]
    [@#database.username=@]
    [@#database.password=@]

!!! Modified
    [@# MS SQLServer connection example@]
    [@# IMPORTANT: The username below is a SQL Server user, not a Windows user.@]
    [@#database.type=SQLServer@]
    [@#database.driver=net.sourceforge.jtds.jdbc.Driver@]
    [@#database.url=jdbc:jtds:sqlserver://localhost/papercut@]''''';ssl=required'''''
    [@#database.username=@]
    [@#database.password=@]

''Categories:'' [[!Databases]]

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.

Article last modified on January 09, 2015, at 12:12 AM
Printable View   |   Article History   |   Edit Article