Mirth Community

Mirth Community (http://www.mirthcorp.com/community/forums/index.php)
-   Support (http://www.mirthcorp.com/community/forums/forumdisplay.php?f=6)
-   -   SQL Server 2019 (http://www.mirthcorp.com/community/forums/showthread.php?t=221867)

jimggmx 11-29-2019 01:56 AM

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?

mike_pose 12-04-2019 07:27 AM

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

All times are GMT -8. The time now is 01:35 PM.

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