Liferay sql server configuration

The below are the steps for configuring the LIferay with SQLServer

Download sqljdbc4.jar and place it in  tomcat bin folder(eg: C:\Liferay\liferay_tomcat\tomcat-7.0.27\lib)

Download sqljdbc4.jar and place it in  tomcat bin folder

Download sqljdbc4.jar and place it in tomcat bin folder

Go to the path   C:\Liferay\liferay_tomcat\tomcat-7.0.27\webapps\ROOT\WEB-INF\classes

select/create portal-ext.properties file

select/create portal-ext.properties file

Add these lines in it

jdbc.default.driverClass=com.microsoft.sqlserver.jdbc.SQLServerDriver

jdbc.default.url=jdbc:sqlserver://SYSTEM003\\SQLEXPRESS:1433;databaseName=Northwind

jdbc.default.username=username

jdbc.default.password=password

Restart the server

Select sqlserver in Database

Fill the confuration details as specified in portal-ext properties file

Select SQLServer as database and give the corresponding settings in the fields

Select SQLServer as database and give the corresponding settings in the fields

Once the settings are properlly given,Liferay is successfully configured with SQLServer.

Configuring SQLServer

Configuring SQLServer

SQLServer successfully configured with Liferay

SQLServer successfully configured with Liferay

Comments

comments