To Configure Web Space Server to Use Microsoft SQL

1. Add the following text to theportal-ext.properties file in theRoot-Dir/webspace-for-gfv2/var/webspace/war-workspace/customs/webspace/WEB-INF/classes directory.

   # SQL Server
       #
       jdbc.default.driverClassName=net.sourceforge.jtds.jdbc.Driver
       jdbc.default.url=jdbc:jtds:sqlserver://localhost:1433/lportal
       jdbc.default.username=sa
       jdbc.default.password=<admin password set for MsSQL>

2. Download the jTDS JDBC driver from http://jtds.sourceforge.net/.

3. Copy the JAR file to the GlassFish-install-dir/domains/domain1/lib directory.

4. Restart the GlassFish server.