Connecting to an Azure Database

I am trying to connect to an Azure SQL database from my Ubuntu installation. I have successfully pinged the server and it seems that my connection string is valid, however I get the following error: An error occurred while establishing the connection: Cannot open database 'xxxxx' on server 'xxxxx' requested by the login. Access to the database is only allowed using a security-enabled connection string. I talked to the support folks who told me that while they don't officially support connecting to Azure, that there were others that were currently able to do so. I am hoping that someone may have found the same error and figured out how to fix it. Thanks in advance!

Hi, Most likely, you need to connect over an SSH Tunnel: http://confluence.dbvis.com/display/UG92/Using+an+SSH+Tunnel Best Regards, Hans