I have the exact same problem as David. The problem is that Azure doesn't allow you to query the master database. However, when creating the database connection in Outsystems I already provide the database I want to use. The test connection went OK.
In Integration Studio I choose the database connection and then instead of showing the database I already specified, Outsystems is trying to create a list of available databases. For this it queries the master database, which is not allowed.
Best solution is that Outsystems uses the database that is specified in the connection. Or is there another?
I am also running into this issue during my eval of OutSystems?
Is there a solution or workaround?
Hello David, Peter and Dwight
Can you tell me if in your ServiceCenter the DBMS dropdown in the Database Configurations has the option "SQL Server / SQL Azure"?
If you only have the "SQL Server" option, check if the Platform Server version is above 9.1.400.0. You can see this on the right side of the screen in Service Center.
As previously said, Azure is only supported after version 9.1.400.0 of the Platform Server. Currently the personal environments are running the 9.1.301.0 version which still does not support Azure.
Is there going to be a release of the personal environments in the near future with this support? It would certainly assist in our evaluation.
I can confirm that I do NOT see the option SQL Azure in the screen you mentioned. I only see SQL Server. My version of Service Studio is 9.1.501.0 and I'm using the Personal Environment.
Thanks for your answer, however it is still a pity that we're not able to access an Azure database... :-)
Running Service Studio and/or Integration Studio on 9.1.501 won't help you.
The connection to SQL Azure is a server-side feature and therefore does not depend on the version of the client-side tools.
Your Personal environment on the OutSystems cloud should now be running 9.1.301, as you can check by browsing to https://<your_environment>.outsystemscloud.com/servicecenter. Check the screenshot in Joao Amorim's reply for an example of how to check the version number.
The Personal environments are upgraded regularly, so it should be a matter of a few weeks.