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

Installing SQL Server 2005

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

• You should have completed reviewing the Planning for SQL Server 2005 topic.
• You must install SQL Server 2005 separately from WebSphere Portal Express.
• WebSphere Portal Express requires Microsoft^® SQL Server Enterprise Edition 2005 Service Pack 2 and DataDirect Connect for JDBC 3.7 JDBC driver. You can obtain these drivers from DataDirect Technologies, http://www.datadirect.com/products/jdbc/index.ssp. The JDBC driver consists of two parts: the JDBC driver libraries and JTA libraries. The JDBC driver libraries must be put on the WebSphere Portal Express system, while the JTA libraries are intended for SQL Server 2005.

1. Purchase and download DataDirect Connect for JDBC and save file 360connectjdbc.jar in a temporary work directory.
2. To create the required files, run the following command from the directory that contains jar -xvf 360connectjdbc.jar
3. Run ./Installer.sh in the same directory.
4. When installation is complete, change directory to /installation/lib, where installation is the directory in which you installed the DataDirect Connect for JDBC 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.

The following section provides instructions for installing SQL Server 2005 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 2005 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. Enable TCP/IP connectivity in the SQL Server Configuration Manager.
5. Install Microsoft SQL Server 2005 Service Pack 2.
6. Enable the JTA functionality for the JDBC driver:

   1. Open the SQL Server Management Studio and log in as the system administrator, sa.
   2. Click File > Open > File... to open the SQL script instjdbc.sql.
   3. Click Query > Execute to run the script.
7. Network the connections for MSDTC in the Windows Component Services as described in Microsoft Help and Support.
8. Start SQL Server 2005.
9. 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 2005 on Windows XP SP2, Windows XP 64-Bit Edition, or Windows Server 2003. Create a additional value in the Windows registry for WebSphere Portal Express by following these steps:

   1. Open theWindows Registry Editor (regedit) and navigate to the element HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC\XADLL.
   2. From the menu bar, select Edit > New > String Value to create a new parameter named sqljdbc.dll in that element.
   3. 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.