Connection with SQL Server Azure
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.
A table seems to have a non-clustered index, but which one?
First, for Azure the Microsoft JDBC driver (
sqljdbc4.jar) should be used as the open source jTDS driver can't manage to authenticate with Azure.
user2group (and maybe
group2group if you use groups of groups) are indeed created without clustered indexes. You may want to recreate them with the proper clustered index:
DROP INDEX [groupid_idx] ON [user2group]; DROP INDEX [parentgroupid_idx] ON [group2group]; CREATE CLUSTERED INDEX [groupid_idx] ON [user2group]; CREATE CLUSTERED INDEX [parentgroupid_idx] ON [group2group];