+

Search Tips   |   Advanced Search


Install SQL Server


prerequisites

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

  1. Install SQL Server and all required patches.

  2. Select the authentication mode for this installation:

    • Windows Authentication Mode

    • Mixed Mode (Windows Authentication and SQL Server Authentication)

    Either authentication mode allows the user who is specified as the database administrator in the wkplc_comp.properties file to log in to the SQL server. Mixed Mode authentication allows either a Windows user or a SQL server user, or both, to log in to the SQL Server.

  3. In the SQL Server Setup panel, Components to Install, select the following components, which are required services for WebSphere Portal:

    • SQL Server Database Services

    • Integration Services

      The option Integration Services, creates the directory DTS/Binn, where copy files when install Microsoft SQL Server JDBC drivers and enable XA connections.

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

  5. Enable TCP/IP connectivity in the SQL Server Configuration Manager.

  6. Install the JDBC driver using one of these methods:

    • Installing DataDirect Connect for JDBC drivers on UNIX

    • Installing DataDirect Connect for JDBC drivers on Windows

    • Installing Microsoft SQL Server JDBC drivers and enabling XA connections

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

  8. Start SQL Server.

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

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

Installing Microsoft SQL Server JDBC drivers and enabling XA connections

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

  2. Copy file sqljdbc_xa.dll from the xa subdirectory to the C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqljdbc_xa.dll directory of the SQL Server 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.

  8. For Microsoft SQL Server 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 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_xa.dll in that element.

    3. Change the value of the new parameter to the location of the sqljdbc_xa.dll file copied in Step 2 above, for example: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqljdbc_xa.dll


Parent topic:

Configure WebSphere Portal to use SQL Server


Next topic:

Modifying database properties