Install SQL Server

 

+
Search Tips   |   Advanced Search

 

You are here
Plan for SQL Server Install SQL Server (Current task) Create databases and users for SQL Server Transfer SQL Server manually or Transfer between databases manually Verify database connections

This section explains how to install Microsoft SQL Server Enterprise Edition for use with IBM WebSphere Portal.

 

Before you begin

• You should have completed reviewing the Planning for SQL Server section appropriate for the database.

 

Requirements

• You must 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. We can download these drivers from http://www.microsoft.com/sql/downloads.

 

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 SP3a 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. Execute 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 the operating system.

 

Installing SQL Server

The following section provides instructions for installing SQL Server for use with IBM WAS 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 Service Pack 3a.

5. Install SQL Server JDBC Type 4 drivers.

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

   jdbc_root\SQLSERVER\instjdbc.sql

   ...from the 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 servername -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

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

   • sql__root is the root directory for the SQL Server 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 2003 or XP, refer to the http://www.jsiinc.com/SUBN/tip6800/rh6866.htm document for information on a new security constraint and how to set SQL Server on Windows 2003 and XP.

    Create a additional value in the Windows registry forWebSphere Portal 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

• Create databases and users for SQL Server

 

Parent topic:

Install databases

 

---