Solaris stand-alone: Install SQL Server

View the steps to install SQL Server for use with WebSphere Portal.

Before you begin this task, complete the following prerequisites:

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

• You must install SQL Server separately from WebSphere Portal.

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

  • You can obtain the Microsoft SQL Server JDBC Driver from Microsoft.
    The driver must be a JDBC 4.0 compliant driver.

The following section provides instructions for installing SQL Server 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 and all required patches.

2. Select the Mixed Mode (Windows Authentication and SQL Server Authentication) authentication mode for this installation.

   Mixed Mode authentication allows either a Windows user or an SQL Server user, or both, to log in to the SQL Server; however, WebSphere Portal requires the user to be an SQL Server user.

3. In the SQL Server Set up 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 you need to copy files when you install MicrosoftSQL 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:

   • DataDirect Connect for JDBC drivers:

     1. Purchase, download, and install the DataDirect Connect for JDBC; see DataDirect JDBC Drivers for information.

     2. Enable XA connections; see Understand XA Transactions for information.

   • Microsoft SQL Server JDBC drivers and enabling XA connections:

     1. Download and install the Microsoft SQL Server JDBC driver; see Microsoft Download Center for information.

     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

7. Start SQL Server.

Parent

Set up a SQL Server database

Next topic

Modify SQL Server database properties

  Updated link in step 6b for enabling XA connections. Removed requirement of SQL Server Integration Services (SSIS). The men...

+

Search Tips   |   Advanced Search