Install SQL Server

 

+
Search Tips   |   Advanced Search

 

Before you begin

Review the Plan SQL Server section appropriate for your database.

 

Requirements

Install SQL Server separately from WebSphere Portal.

WebSphere Portal requires Microsoft JDBC Type 4 drivers with Service Pack 3 or Service Pack 2 and requires SQL Server 2000 SP3a for JDBC.

 

Install Microsoft JDBC Type 4 drivers on UNIX

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

  1. Download the Microsoft JDBC Type 4 drivers for SQL Server 2000 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.

 

Install SQL Server

The following section provides instructions for installing SQL Server for use with WebSphere Application Server and WebSphere Portal. 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 JDBC driver.

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

  6. Start SQL Server.

  7. Use the ISQL utility to run instjdbc.sql from the sql_jdbc_root\SQLSERVER JTA directory, where sql_jdbc_root is the root directory for the SQL Server JDBC driver. The DOS prompt syntax is 

    ISQL -U sa -P sa_password -S server_name -i "sql_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

    • sql_jdbc_root is the root directory for the SQL Server JDBC drivers

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

  9. If you are running Windows 2003, Refer to the following document http://www.jsiinc.com/SUBN/tip6800/rh6866.htm for information on a new security constraint and how to set SQL Server on Windows 2003.

    For WebSphere Portal, create a value name in the registry similar to the following:

    • Value Name: String Value

    • sqljdbc.dll: C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqljdbc.dll

    • Old Component: wpo_was

    • New Component: wpo_docs

 

Next steps

 

WebSphere is a trademark of the IBM Corporation in the United States, other countries, or both.

 

IBM is a trademark of the IBM Corporation in the United States, other countries, or both.