I needed to install the EXPRESS version of MSSQL 2008 and this version dictates to get installed with a named instance, but i need to have it as default instance. (and I couldn't)
Now the root of the case is that I have the following ROOT.xml of Catalina tomcat and I couldn't set it up to run the named instance db.
<?xml version='1.0' encoding='utf-8'?>
Replace the username, password and url parameters.
In the URL the name after the last slash is the database name.
The database must have been created, but be otherwise empty.
<Resource name="jdbc/Test" auth="Container" type="javax.sql.DataSource" username="test" password="test" driverClassName="net.sourceforge.jtds.jdbc.Driver" url="jdbc:jtds:sqlserver://localhost:1433/JAZZ" maxActive="8" maxIdle="4" />
<!-- This is needed to use SQLServer -->
<Environment name="hibernateDialect" value="org.hibernate.dialect.SQLServerDialect" type="java.lang.String" override="false" />
Essentially when i changed the localhost to my named instance, it's not working. It is working as above but I need to have it working with SQLEXPRESS.