web stats
Configure Mirth to use Kerberos authentication with MS SQL Server with SSL - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

View Poll Results: Did this help you use Mirth with SQL Server?
Yes 1 100.00%
No 0 0%
Voters: 1. You may not vote on this poll

Reply
 
Thread Tools Display Modes
  #1  
Old 04-02-2018, 07:23 AM
Derrick Derrick is offline
What's HL7?
 
Join Date: Apr 2018
Posts: 1
Derrick is on a distinguished road
Default Configure Mirth to use Kerberos authentication with MS SQL Server with SSL

How to configure Mirth Connect to use kerberos authentication to talk over a SSL encrypted channel to MS SQL Server:

Download MS JDBC driver: https://go.microsoft.com/fwlink/?linkid=852460
Explode the archive.
Copy sqljdbc_auth.dll from the x64 directory to %Program Files%\Mirth Connect\server-lib\database.
Copy sqljdbc42.jar from the archive to %Program Files%\Mirth Connect\server-lib\database.

In %Program Files%\Mirth Connect\conf\mirth.properties:
Set database = sqlserver
Set database.url = jdbc:sqlserver://oa-130d-ch-db1.dev.lan:1433;integratedSecurity=true;databaseN ame=dbname
Set database.driver = com.microsoft.sqlserver.jdbc.SQLServerDriver

In %Program Files%\Mirth Connect\conf\dbdrivers.xml:
Add this <driver> node under the <drivers> node:
<driver class="com.microsoft.sqlserver.jdbc.SQLServerDrive r" name="SQL Server" template="jdbc:sqlserver://hostort/dbname" selectLimit="SELECT TOP 1 * FROM ?" />

Add %Program Files%\Mirth Connect\server-lib\database to the PATH environment variable.

Last edited by Derrick; 04-02-2018 at 10:33 AM. Reason: Forgot important tidbit.
Reply With Quote
Reply

Tags
jdbc, kerberos, mirth, sqlserver, ssl

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -8. The time now is 03:24 AM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2019, vBulletin Solutions, Inc.
Mirth Corporation