To Install and Configure Microsoft SQL

This procedure provides basic Microsoft SQL installation instructions, and explains how to configure Microsoft SQL to work with Web Space Server. For complete Microsoft SQL installation instructions see the Microsoft SQL Server page.

Before You Begin

Before proceeding with these instructions, make sure the following are installed on your Web Space Server system:

• .NET Framework 3.5

• Windows Installer 4.5

• Windows Power Shell

1. Install SQL Server Express 2008 with Management Tools.

   Refer to the Microsoft site for complete download and installation instructions.

2. Navigate to the Microsoft SQL Server Configuration page, and change the following values:

   • Use NT AUTHORITY\SYSTEM as the SQL Server account name.

   • Change the SQL Server browser startup to Automatic.

3. Navigate to the Microsoft SQL Server Database Engine Configuration page, and change the following values:

   • Select Mixed Node.

   • Specify a password for the sa account.

4. Start the Microsoft SQL server.

   1. Run the Microsoft SQL Server Configuration Manager.

   2. Navigate to SQL Server Network Configuration->Protocols for SQL SERVER, and enable TCP/IP and Named Pipes (SQL server uses port 1433 by default).

   3. Right click SQL Server Services->SQL Server, and then click Start.

   4. Verify the database is running.

      You can verify this in Solaris by entering netstat -an | grep 1433 at a command prompt:

5. Connect to the Microsoft SQL server using the Management Studio tool.

   1. Launch the SQL Server Management Studio.

   2. Navigate to File->Connect Object Explorer.

   3. Apply the following settings:

      • Server Type: Database Engine

      • Server Name: host_name

      • Authentication: SQL Server Authentication. Note that to use SQL Server authentication, you need to select the Mixed Mode (Windows authentication + SQL Server authentication) option when installing Microsoft SQL.

      • Login: sa

      • Password: Administrator password defined during Microsoft SQL installation.

   4. Click Connect.

   5. Select New Query in the Management Studio tool.

   6. Enter create database lportal, and then click Execute.

      The message “Query executed successfully” is displayed on successful creation of the database named lportal.

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

7. Copy the jtds.jar file to the gf-install-dir/domains/domain1/lib directory.

8. Proceed to To Connect to a Database Other Than HSQL for additional configuration instructions.