MySQL 5.x (or later versions) or Oracle 10g (or later versions) are officially supported for a production environment. MySQL is the default database for the production environment but you can install and configure Web Space Server for other databases as well.
You must have the following software installed:
.NetFramework 3.0 and above
Windows Installer 4.5 and above
Windows Power Shell
Download SQL Server 2008 Express with Tools/SQL Server 2008 Express Advanced Series.
Run the SQLEXPRADV_x86_ENU.exe file.
Click the System Configuration Checker in the SQL Server Installation Center to see if all the prerequisites are installed.
Choose Installation.
Type the product key and click Next.
The product key setting page appears.
Accept the licence terms and click Next.
The licence terms page appears.
Click Install in the Set Up Support Files screen. Click Next on completing the setup.
In the Features Selection screen that appears, select the Database Engine Services and ManagementTools-Basic features.
Type MSSQLSERVER in the Named instance and Instance ID boxes for Instance configuration. Click Next.
See http://msdn.microsoft.com/en-us/library/ms165614.aspxfor more information about configuration.
Make the following changes in the Server Configuration page
Use NT AUTHORITY\SYSTEM as the account name for SQL Server Database engine.
Change the SQL Server browser startup to Automatic.
Other settings remain the same.
Do the following changes in the Database Engine Configuration screen:
Run MSSQL Server Configuration Manager.
Navigate to SQL Server Network Configuration -> Protocols for SQL SERVER. Enable TCP/IP and Named Pipes. SQL server uses port 1433 by default.
Right-click SQL Server Services and choose SQL Server from the pop-up menu. Click Start.
Verify that Microsoft SQL is running.
You can verify this on the Solaris platform by running the netstat -an | grep 1433 command in a terminal window.
Run SQL Server Management Studio.
Navigate to File -> Connect Object Explorer.
Apply the following settings:
Server Type: Database Engine
Server Name: Name of the computer
Authentication : SQL Server Authentication. In order to use SQL Server authentication, you need to select the Mixed Mode (Windows authentication + SQL Server authentication) option while installing Microsoft SQL.
Login : sa
Password : MSSQL administrator password assigned during installation
Click Connect.
Select New Query in the Management Studio tool.
Type create database lportal and click Execute.
The message “Query executed successfully” is displayed on successful creation of the database named lportal.
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>
Download the jTDS JDBC driver from http://jtds.sourceforge.net/.
Copy the JAR file to the GlassFish-install-dir/domains/domain1/lib directory.
Restart the GlassFish server.