web stats
SQL Server 2019 - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Thread Tools Display Modes
Old 11-29-2019, 01:56 AM
jimggmx jimggmx is offline
What's HL7?
Join Date: Mar 2014
Posts: 1
jimggmx is on a distinguished road
Default SQL Server 2019

For compatability reasons I am trying to run Mirth 3.2.1 on Windows server with SQL Server 2019. The intention is to move a Mirth set up from an old server to a new one. I cannot create/connect to a SQL database for Mirth itself.
I have tried ceating a new mirthdb and also a copy of the old mirthdb restored into SQL server 2019

I am using the same database setup as in the old server:
jdbc:jtds:sqlserver://locahost:1433/mirthdb;create=true and the same username and password. I have created the required user in SQL server. The file mirth.log indicates that the user login failed.

Have I run into a compatability issue with the jdbc driver and SQL server 2019?
Reply With Quote
Old 12-04-2019, 07:27 AM
mike_pose mike_pose is offline
What's HL7?
Join Date: Sep 2019
Posts: 5
mike_pose is on a distinguished road

It might be that the default jtds JDBC driver is not compatible with SQL Server 2019. Try using the official latest Microsoft JDBC driver (https://docs.microsoft.com/en-us/sql...l-server-ver15).
We're using SQL Server 2017, but had to use the MSFT driver to support Active Directory authentication.
You'll need to adjust the connection string format and specify the driver in mirth.properties

database.driver = com.microsoft.sqlserver.jdbc.SQLServerDriver
Reply With Quote

sql 2019

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 08:22 PM.

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