Installation guide

TIBCO ActiveMatrix BPM Installation and Configuration
36
|
Chapter 3 Pre-Installation Tasks
3. Connect to SQL Server 2008 Management Studio as an administrator of the
SQL Server Instance.
4. From the location where you installed the Microsoft SQL Server JDBC Driver,
run the sqljdbc_n.n\enu\xa\xa_install.sql script against the master database
where n.n is the version number of the Microsoft SQL Server JDBC Driver you
are using. The first time you run this you may see errors about failing to drop
procedures. These errors may be ignored as the procedures do not exist yet.
5. Depending on your operating system, from the location where you installed
the Microsoft SQL Server JDBC Driver, copy either
— sqljdbc_n.n\enu\xa\x86\sqljdbc_xa.dll, or
— sqljdbc_n.n\enu\xa\IA64\ sqljdbc_xa.dll, or
— sqljdbc_n.n\enu\xa\x64\ sqljdbc_xa.dll file
to the Binn folder of the SQL server being used (for example, C:\Program
Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Binn)
where n.n is the version number of the Microsoft SQL Server JDBC Driver you
are using.
6. Click Control Panel > Administrative Tools.
7. Double-click Component Services. The Component Services dialog is
displayed.
8. Drill down to Component Services > Computer > My Computer >
Distributed Transaction > Local DTC.
9. Right-click Local DTC and select Properties. The Local DTC Properties
dialog is displayed.
Click Security. Make sure the Enable XA transactions check box is selected.
Using Oracle 11g
Create Database Instance with Character Set AL32UTF8 for Multilingual
Data
When creating the Oracle database instance, ensure that you select the AL32UTF8
character set for multilingual data.
AL32UTF8 supports the latest version of the Unicode standard and provides a full
supplementary character support. (Examples of supplementary characters
include Chinese, Japanese, Korean, gothic, mathematical, or musical.)