Nuxeo DM with SQL Server Express 2008 - trouble setting up.

Hi, I'm trying to use sql express 2008 with Nuxeo DM. Here's a part of the config file:

# nuxeo.templates=default
# nuxeo.db.user=nuxeo
# nuxeo.db.password=password

but the database isn't created and in the server logs I have:

2011-09-22 18:05:01,265 ERROR [org.nuxeo.ecm.platform.ui.web.auth.plugins.AnonymousAuthenticator] java.lang.RuntimeException: Unkown user directory userDirectory

…which it seems that at the end of the stack trace comes from

org.nuxeo.ecm.core.api.WrappedException: Exception: message: localhost\sqlexpress
  at Source)
  at Source)
  at Source)
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
  at java.lang.reflect.Method.invoke(Unknown Source)
  at net.sourceforge.jtds.jdbc.SharedSocket.createSocketForJDBC3(
  at net.sourceforge.jtds.jdbc.SharedSocket.<init>(
  at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(
0 votes

2 answers



Nuxeo uses jtds for the underlying connection and builds the jdbc url this way: jdbc:jtds:sqlserver://${}:${nuxeo.db.port}/${};useCursors=true

According to what I can see about jtds and named instances you have two options: 1) append “;instance=sqlexpress” to your 2) use the named instance specific port instead of the generic database port

0 votes must be a hostname or IP address, in your case it would be localhost if your MS SQL Express instance is running on the same machine as nuxeo.

0 votes

Yes but as you can see the server is set up as a named instance (SQLEXPRESS), so localhost isn't sufficient. Does NUXEO support connecting to named instances of SQL Server? Thank you for your time.