jdbc - Unable to setup connection to Azure SQL from DbFit -

i attempting connect sql azure using following jdbc connection string:

       !|connect|jdbc:sqlserver://xxx.xxxx.xxxx.net,1433;databasename=dbname;user=xxx@xxx;password=xxxx;encrypt=true;logintimeout=30| 

however each attempt result in null error being returned.

i able to connect sql azure ssms.

has got ideas?

how building connection string? can use ones provided @ azure portal, following:

static string connectionurl = "jdbc:sqlserver://{your_server}.database.windows.net:1433;database=test;user={username}@{your_server};password={your_password};encrypt=true;trustservercertificate=false;hostnameincertificate=*.database.windows.net;logintimeout=30"; 

did include pipes in string? can follow tutorial ensure you're following right steps: https://msdn.microsoft.com/en-us/library/azure/gg715284.aspx