Install SQL Server 2005 and all required patches.
2. Select the authentication mode for this installation:
o Windows Authentication Mode
o 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 2005 Setup panel, Components to Install, select the following components, which are required services for WebSphere Portal:
o SQL Server Database Services
o Integration Services
The option Integration Services, creates the directory DTS/Binn, where you will need to copy files when you install Microsoft SQL Server 2005 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:
o Installing DataDirect Connect for JDBC drivers on UNIX
o Installing DataDirect Connect for JDBC drivers on Windows
o Installing Microsoft SQL Server 2005 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 2005.
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:
7. chgrp system_grp *.jar
chown root *.jar
Where system_grp is the system group as labeled by your operating system.
Installing DataDirect Connect for JDBC drivers on Windows
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.bat in the same directory.
Installing Microsoft SQL Server 2005 JDBC drivers and enabling XA connections
1. Download and install the Microsoft SQL Server 2005 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 2005 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.
Note: 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 2005 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 2005 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:
a. Open theWindows Registry Editor (regedit) and navigate to the element HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC\XADLL
b. From the menu bar, select Edit > New > String Value to create a new parameter named sqljdbc_xa.dll in that element.
c. 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
Enable XA Transactions in Windows Component Services
1. From your Windows desktop, follow these steps:
2. Click Start > Settings > Administrative Tools > Component Services.
3. Expand the tree view to locate the computer where you want to turn on support for XA transactions (for example, My Computer).
4. Display the context menu for the computer name and click Properties.
5. Click Options and tune the Transaction Timeout that suits your environment. (The recommended minimum is 180 seconds).
6. Click MSDTC and click Security Configuration.
7. Under Security Settings, select XA Transactions to enable this support.
8. Click OK to save your changes.
Note: The installation documentation for JDBC XA connectivity refers to two known problems, see the Microsoft support site for more information:
· KB899756: Windows 2003 only. MSDTC does not detect process termination, and MSDTC cannot set time-out values for XA transactions in Windows Server 2003.
No comments:
Post a Comment