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:http://sqlserverXXXXXXXXXX.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

Has anyone had any luck connecting to SQLServer in Windows Azure?