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
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.