Portal, V6.1

---

 

Install SQL Server 2005

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

• You should have completed reviewing the Planning for SQL Server 2005 topic.

• You must install SQL Server 2005 separately from WebSphere Portal.

• WebSphere Portal requires Microsoft SQL Server Enterprise Edition 2005 Service Pack 2

• WebSphere Portal requires either the DataDirect Connect for JDBC 3.7 JDBC driver or the Microsoft SQL Server 2005 JDBC Driver.

  • You can obtain the DataDirect Driver from DataDirect Technologies. 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 system, while the JTA libraries are intended for SQL Server 2005.

  • You can obtain the Microsoft SQL Server 2005 JDBC Driver from Microsoft. See the Microsoft SQL Server product documentation for installation details

Installing DataDirect Connect for JDBC drivers on UNIX

1. Purchase and download DataDirect Connect for JDBC and save file 360connectjdbc.jar in a temporary work.

2. To create the required files, run the following command from the directory that contains 360connectjdbc.jar:jar -xvf 360connectjdbc.jar:

3. Run ./Installer.sh in the same.

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.

Installing Microsoft SQL Server 2005 JDBC drivers and enabling XA connections

1. Download and install the Microsoft SQL Server 2005 JDBC driver.

2. Copy file sqljdbc_xa.dll from the xa subdirectory to the 90\DTS\Binn directory of the SQL Server 2005 installation.

3. Start the database server.

4. Ensure that the Distributed Transaction Coordinator has been started. The status can be verified in the list of services in the Computer Management console.

5. Start the Microsoft SQL Server Management Studio and connect to the local database engine as the system administrator, sa.

6. Select File > Open > File and select xa_install.sql from the subdirectory of the downloaded and extracted JDBC driver.

7. Execute the script by selecting Query > Execute.

   Any warnings that appear in the messages section of the application window that say that stored procedures cannot be found can be safely ignored.

The following section provides instructions for installing SQL Server 2005 for use with IBM WebSphere Application Server and WebSphere Portal. These steps are the same for both the DataDirect and Microsoft drivers unless noted.

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. 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.

6. Network the connections for MSDTC in the Windows Component Services as described in Microsoft Help and Support.

7. Start SQL Server 2005.

8. For Microsoft SQL Server 2005 JDBC drivers: 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 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.

 

Parent topic

Configure WebSphere Portal to use SQL Server 2005

Next topic:

Modifying database properties

---