Install SQL Server

Install SQL Server SQL Server for use with WebSphere Portal.

1. Verify the DB is supported by this version of WebSphere Portal.

2. Download a JDBC 4.0 compliant driver from Microsoft

3. Install SQL Server and all required patches.

   In the SQL Server Setup, choose the following:

   1. In the Setup Role panel, choose...
      SQL Server Feature Installation

   2. In the Features Selection panel, choose at least...
      Database Engine Services

   3. In the Database Engine Configuration, select...
      Mixed Mode (SQL Server Authentication and Windows authentication)

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

4. Use the SQL Server documentation as a guide to complete the installation.

5. Install the JDBC driver.

   Use Microsoft SQL Server JDBC drivers and enable XA connections:

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

      See Microsoft Download Center for information.

   2. Copy the sqljdbc_xa.dll file from the xa subdirectory to the SQL Server installation, into...
      C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\sqljdbc_xa.dll

   3. Start the database server.

   4. Verify the Distributed Transaction Coordinator is started.

      Verify this status in the list of services in the Computer Management console.

   5. Start the Microsoft SQL Server Management Studio
      Windows Start button | Run | ssms.exe

   6. Connect to the local database engine as a system administrator, for example, "sa".
      

      Server name is the name of the computer where SQL Server is installed. You can determine server name from portal data source config. For example...

      jcr.DbUrl=jdbc:sqlserver://PREPRD-PORT-DB2.PPDSRV.MYCO:1433;SelectMethod=cursor;DatabaseName=MYDB_PREPROD

   7. Open file...
      File | Open | File | xa_install.sql

   8. Run the script by...
      Query | Execute

      Ignore any warnings that say that stored procedures cannot be found.

   9. To grant permission to a specific user to participate in distributed transactions with the JDBC driver, add the user to the SqlJDBCXAUser role.

6. To enable XA Transactions in Windows Component Services:

   1. Choose Component Services of the Administrative Tools.

   2. Expand the tree view to locate the computer where to turn on support for XA transactions. For example, My Computer.

   3. Display the menu for the computer name and click Properties.

   4. Click Options and tune the Transaction Timeout. The minimum requirement is 180 seconds.

   5. Click OK to save the changes.

   6. Expand...
      Component Services | Computers | My Computer | Distributed Transaction Coordinator | Local DTC (right-click) | Properties | Local DTC Properties | Security tab | the Enable XA Transactions check box | OK.

      This action causes a MS DTC service restart.

7. Start SQL Server.

8. Connect at least one user to the SQL Server instance. A user can be granted permission to use several schema names, so a single user for each instance is sufficient.

What to do next

Use the Configuration Wizard to set up and configure the database to work with WebSphere Portal. Use the wizard to create custom scripts that you or the database administrator can use to configure the database. We can also use the wizard to automatically set up and configure the database. The wizard creates instructions and scripts based on the selections and provided data.

When we use the wizard, you provide information about the database for our environment.

Before we enter the database name (dbdomain.DbName) in the Configuration Wizard, check the database documentation for restrictions on character length.

Parent Install the database software