web stats
Mirth Community - View Single Post - Has anyone had any luck connecting to SQLServer in Windows Azure?
View Single Post
Old 03-21-2016, 02:54 PM
thildemar thildemar is offline
Mirth Newb
Join Date: Mar 2012
Posts: 7
thildemar is on a distinguished road

Thanks Eric,

This fixed my issue. We needed to enable force encrypted connections for our SQL server and JTDS just would not connect with SSL correctly.

I followed your steps to grab the Microsoft driver and used this connection string for the local server:

var dbConn = DatabaseConnectionFactory.createDatabaseConnection('com.microsoft.sqlserver.jdbc.SQLServerDriver', 'jdbc:sqlserver://SERVERNAME:PORT;databaseName=DBNAME', 'USERNAME', 'PASSWORD');
Connected up with no encryption errors. Note that you may need to use sqljdbc4.jar if you are using an older JRE (look in your Mirth log if you run into issues).
Reply With Quote