RDM for IoS wont connect to SQL Azure
Hi,
I am trying to get RDM working on an iPad connecting to our online SQL Azure database. This works great for RDM on our Windows laptops.
When I try to add a SQL Azure Database connection, using database login - it fails to connect. (picture attached)
I am using the same credentials I used for RDM on the Windows laptops.
I have asked a colleague to try on his iPad as well and he gets the same problem.
Any ideas?
Cheers,
Steve
20170425_085450000_iOS.png
All Comments (6)
Hello,
Does the error message appear when you press Select to select the database?
Best regards,
Jeff Dagenais
Yes.... The error pops up after 5 or so seconds.
Cheers,
Steve
Hello,
You mentioned that the connection to the databae is working fine in RDM Windows.
I would like you to export your data source configuration from RDM Windows and import it on your iPad.
To do so, please follow the steps below:
When all those steps are done, you can try to connect on Azure using this data source configuration.
Best regards,
Jeff Dagenais
Hi Steve,
Can you try removing the .secure. from the server name?
The iOS app does not support SQL Server over SSL.
Best regards,
Mathieu Morrissette
Mathieu,
Just tried to remove the ".secure." from the server name and I now get a different error message:
Validation
Unable to connect to the server!
Cannot open database '' on server
'server' requested by the
login. Access to the database is
only allowed using a security-
enabled connection string.
Looks like I might be stuck here? I'll ask our guys who setup the server to see if there is an option to allow "unsecure" access - but they may not want to allow it.
Will the iOS app support secure connections any time soon?
Cheers,
Steve
Hi Steve,
Unfortunately, there is no workaround for this issue. Our app is powered by Mono and we use their client to connect to SQL Servers. We don't know when this feature will be available in Mono or if it will ever be supported.
Best regards
Mathieu Morrissette