Connection with SQL Server Azure

[AxelF_]

Hello.

We're trying to connect Nuxeo to a SQL Server Azure instance with the wizard configuration interface.The instance is OK and we have a private client connected to it. But Nuxeo failed to connect to that SQL instance. Here the exception in logs:

[http-bio-0.0.0.0-8080-exec-1] [org.nuxeo.wizard.RouterServlet] java.sql.SQLException: I/O Error: DB server closed connection.

It works on a local instance but not on an Azure instance. Here the wizard conf:

Database Type: MS SQL Server Database Name: MyDatabase Database user: user@myAzureSqlInstance Database Server host name: myAzureSqlInstance.database.windows.net Database server port: 1433

The port is openned.

[AxelF_]

Ok we managed solve some exceptions. But the "starting process is taking to long" is still here. And when we're trying to logging in

[Florent_Guillau]

It's happening in the Jena code (used for relations on old Nuxeo versions and still checked for compatibility reasons in recent versions) so the tables must be some of the JENA_* tables.

[AxelF_]

The problem could be that I don't have any table containing JENA in table_name. There are 153 tables.

[AxelF_]

We're still stucked with this Azure SQL database problem. We can't get it...