LP 5.2.2 with MS SQL Server 2008 Express Editon

[Gerald Ortner, modificado hace 14 años.]

Hi all,

I tried to use Liferay Portal 5.2.2 (bundle withTomcat 6.0.18) together with MS SQL Server 2008 Express Edition. To configure this I followed this wiki article: http://www.liferay.com/web/guest/community/wiki/-/wiki/Main/Tomcat+with+SQL+Server+2008
This and other tries with another jdbc driver didn't work.

Tomcat Log:

Loading file:/C:/Program%20Files/Liferay/tomcat-6.0.18/webapps/ROOT/WEB-INF/classes/portal-ext.properties
08:14:09,737 ERROR [DialectDetector:114] java.sql.SQLException: Connections could not be acquired from the underlying database!
java.sql.SQLException: Connections could not be acquired from the underlying database!
        at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)

Platform: Windows Server 2008
JRE: 1.6.0.13


Any ideas?

[Amos Fong, modificado hace 14 años.]

Hi Gerald,

One thing that took me a long time to figure out was that SQL Server disables TCP connections by default.

http://msdn.microsoft.com/en-us/library/bb909712.aspx

Also I had to add the port number to the URL (in my case 2342). So my settings are:

jdbc.default.driverClassName=net.sourceforge.jtds.jdbc.Driver
jdbc.default.url=jdbc:jtds:sqlserver://localhost:2342/lportal
jdbc.default.username=sa
jdbc.default.password=liferay

Hope that saves someone some time.