web stats
Has anyone had any luck connecting to SQLServer in Windows Azure? - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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
 

Tags
cloud, sql server, windows azure

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:31 PM.


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