Can't connect to Azure SQL Server

CloverDX Platform
1

Hi we currently use other tools like PowerAutomate etc. to connect to to an Azure SQL Server. I’m now trying to use CloverDX Designer.

I choose “New Connection” in the Connections outline pane and then click “MS SQL Server 2008 or newer” in the Available drivers window. I then enter the URL below it e.g. https://myserver.database.windows.net. I add the SQL Server user credentials and then click “Validate connection”.

I then get the following error:

com.cloveretl.server.api.wsjdbc.generated.SqlFault_Exception: org.jetel.exception.ComponentNotReadyException: Unacceptable connection URL: https://myserver.database.windows.net.

Obviously I’m using “myserver” in my example above but I do supply the correct URL.

2

OK I noticed I had to doubleclick and it pre-populates the URL and I can update to:

jdbc:sqlserver://myserver.database.windows.net:1433;databaseName=dbname

3

Hi Nick,

Thank you for your post. I’m glad to see you’ve found a solution!
Please let us know if you have any further questions.

Hana