WebSphere

 

Portal Express, Version 6.0
Operating systems: i5/OS, Linux, Windows

 

Install SQL Server

This section provides information on how to install SQL Server for use with WebSphere Portal Express.

 

Before you begin

 

Requirements

Installing Microsoft JDBC Type 4 drivers on Linux Use the following steps to install Microsoft JDBC Type 4 drivers on Linux:

  1. Download the Microsoft SQL Server 2000 Driver for JDBC SP3 and save the mssqlserver.tar file in one of the directories.

  2. To create the required files, run the following command from the directory that contains mssqlserver.tar: tar -xvf mssqlserver.tar

  3. Run ./install.ksh in the same directory.

  4. When installation is complete, change directory to /installation/lib, where installation is the directory in which you installed the Microsoft JDBC Type 4 drivers.

  5. Run the following command to change the permissions on the JAR files in the installation/lib directory:chmod 777 *.jar

  6. Change the ownership and group of these files by running the following commands in the installation/lib directory: 

    chgrp system_grp *.jar chown root *.jar

    Where system_grp is the system group as labeled by your operating system.

Installing SQL Server

The following section provides instructions for installing SQL Server for use with IBM® WebSphere® Application Server and WebSphere Portal Express. See the Microsoft SQL Server product documentation for installation details.

  1. Install SQL Server and all required patches.

  2. Select SQL Server Authentication as the authentication mode during the installation.

  3. Complete the installation using SQL Server documentation as a guide.

  4. Install the Microsoft SQL Server Service Pack 4.

  5. Install Microsoft SQL Server 2000 Driver for JDBC Service Pack 3.

  6. Copy sqljdbc.dll from jdbc_root\SQLSERVER JTA directory to the sql_root\binn directory, where jdbc_root is the root directory for the JDBC Driver and sql_root is the root directory for the SQL Server driver.

  7. Start SQL Server.

  8. Use the ISQL utility to run instjdbc.sql from the jdbc_root\SQLServer JTA directory, where jdbc_root is the root directory for the JDBC Driver. The DOS prompt syntax is: 

    ISQL -U sa -P sa_password -S server_name -i "jdbc__root\SQLSERVER JTA\instjdbc.sql"
    where

    • sa is the SQL Server system administrator user ID

    • sa_password is the password for the system administrator

    • server_name is the name of the server on which SQL Server is running

    • jdbc__root is the root directory for the JDBC drivers

  9. A message indicating success is shown. Review the message output for messages that indicate an installation or execution error.

  10. If you are running Windows XP SP2, Windows XP 64-Bit Edition, or Windows Server 2003, refer to the Registry Entries Are Required for XA Transaction Support document for information on a new security constraint and how to set SQL Server on Windows XP SP2, Windows XP 64-Bit Edition, or Windows Server 2003.

     Create a additional value in the Windows registry forWebSphere Portal Express by following these steps:

    • Open theWindows Registry Editor (regedit) and navigate to the element HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC\XADLL.

    • From the menu bar, select Edit > New > String Value to create a new parameter named sqljdbc.dll in that element.

    • Change the value of the new parameter to the location of the sqljdbc.dll file copied in step five above, for example: C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqljdbc.dll.

Next steps

You have completed this step. Continue to the next step.

 

Parent topic:

Configuring SQL Server

 

Previous topic

Planning for SQL Server

 

Next topic

Creating databases and users for SQL Server