web stats
Mirth Community - View Single Post - Has anyone had any luck connecting to SQLServer in Windows Azure?
View Single Post
  #1  
Old 03-20-2015, 11:52 AM
EricD EricD is offline
Mirth Newb
 
Join Date: Oct 2009
Posts: 14
EricD is on a distinguished road
Default Has anyone had any luck connecting to SQLServer in Windows Azure?

Hello all, we're trying to move HL7 messages to a SQLServer instance running in Windows Azure, but have had zero luck getting it to go through successfully.

We're using the DB Writer destination type, and have tried both Javascript and not.

We've tried the following connection string, with variations:

Code:
jdbc:jtds:sqlserver://XXXXXXXXXX.database.windows.net:1433;database=phi;user=XXXXXXX;password=XXXXX;encrypt=true;hostNameInCertificate=*.database.windows.net;loginTimeout=30;
Of course, we're attempting to connect with encryption and SSL.

We've even tried replacing the open source SQLServer driver with the Microsoft one (com.microsoft.sqlserver.jdbc.SQLServerDriver).

So, have any of you had any success, and could point us in the right direction?

Thanks,
Eric
Reply With Quote