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

[elteo_]

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

# nuxeo.templates=default
nuxeo.templates=mssql
# nuxeo.db.user=nuxeo
nuxeo.db.user=nuxeo\_db\_user
# nuxeo.db.password=password
nuxeo.db.password=123
# nuxeo.db.host=localhost
nuxeo.db.host=localhost\\sqlexpress

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: java.net.UnknownHostException. message: localhost\sqlexpress
  at java.net.PlainSocketImpl.connect(Unknown Source)
  at java.net.SocksSocketImpl.connect(Unknown Source)
  at java.net.Socket.connect(Unknown 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(SharedSocket.java:305)
  at net.sourceforge.jtds.jdbc.SharedSocket.<init>(SharedSocket.java:255)
  at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:323)

[#2]

nuxeo.db.host 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.

[elteo_]

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.

[#4 · Accepted solution]

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

According to what I can see about jtds and named instances you have two options:

1. append ";instance=sqlexpress" to your nuxeo.db.name
2. use the named instance specific port instead of the generic database port