Azure SQL Connection issue


#1

Hi, I am new to Dreamfactory, but I believe this will sort my requirements nicely.
I want to setup a connection to a Azure sql database,
In services I have filled in the details as required, but the connection fails in data or schema "failed to launch service"
My credentials and connection string should be correct , what am I missing?
dblib:host=xxx.database.windows.net:1433;dbname=xxx


#2

Check out this blog post:

For MS SQL and Azure this would be port 1433, and you would add @servername to your user name in the service configuration such as ‘dreamfactory@r92ul6qcff’.

This forum post also covers the need to format your connection string with username@. This is documented by Microsoft here.

If this does not help, please reply back with the error(s) from your DreamFactory log.