|
Configuring the SQL Server data source requires you to
install the SQL Server database drivers, create a SQL Server JDBC
provider on WebSphere, create the data source on WebSphere, and
then configure the corresponding connection pool.
Install the SQL Server database driverIf
you have not done so already, copy the SQL Server JDBC Driver from
[LiveCycle root]\lib\db\mssql to the [appserver root]\idplib\
directory.
Note: Make a note of the directory location where
you install the driver on your system.
Create the SQL Server JDBC providerIn the WebSphere Administrative Console navigation tree,
click Environment > WebSphere Variables and, in
the right pane, click one of the following:
Under General Properties, in the Value box,
type the path to the sqljdbc4.jar file that you created in the Install the SQL Server database driver section,
and then click OK.
In the Messages box, click Save directly to
master configuration.
In the navigation tree, click Resources > JDBC > JDBC Providers.
In the Scope drop-down list in the right pane, select Node=NodeName, Server=ServerNameas
the level, and then click New.
In the Create new JDBC provider pane, set the following
configurations and then click Next:
In the Database type list,
select SQL Server.
In the Provider Type list, select Microsoft SQL Server JDBC Driver.
In the Implementation type list, select Connection Pool Data Source.
In the Name box, type Microsoft SQL Server JDBC Driver,
or accept the default value.
In the Enter database class path information pane,
replace the existing entry with the following, and then click Next:
Note: For WebSphere, if you have set the WebSphere variable MICROSOFT_JDBC_DRIVER_PATH,
the database class path information is populated automatically.
In the Summary pane, click Finish and then
click Save directly to master configuration.
Create the SQL Server data source for LiveCycleFollow
the steps below to create the SQL Server data source for your application server
version.
In
the navigation tree, click Resources > JDBC > JDBC Providers and,
in the right pane, click the provider that you created in the Create the SQL Server JDBC provider section.
Under Additional Properties, click Data sources and
then click New.
In the Enter basic data source information pane, set
the following configurations and then click Next:
In the Data source name box, type Livecycle - SQLServer - IDP_DS.
In the JNDI name box, type IDP_DS.
In the Enter database specific properties for the data source pane,
enter the database name, server name, and port.
In the Setup security aliases pane, set the following,
and click Next.
In the Summary pane, click Finish, and then
click Save directly to the master configuration.
Set the data store helper class for the data source. Do the
following tasks:
In the navigation tree, click Resources > JDBC > Data sources and,
in the right pane, click the data source that you created.
In the next screen, under Data store helper class name,
select Specify a user-defined data store helper, and replace
the existing entry with the following text:
com.ibm.websphere.rsadapter.GenericDataStoreHelper
Change the statement cache size. Do the following tasks:
In WebSphere Administrative Console, click JDBC > Data sources.
Click the data source you just created and under Additional Properties, click WebSphere Application Server data source properties.
Change the value of the Statement cache size field
to 80.
Click OK or Apply and the click Save directly
to the master configuration.
Configure LiveCycle - SQLServer - IDP_DS connection poolsIn the navigation tree, click Resources > JDBC > JDBC Providers and,
in the right pane, click the provider that you created earlier for
WebSphere.
Under Additional Properties, click Data sources and
then select Livecycle - SQLServer - IDP_DS.
On the next screen, under Additional Properties, click Connection Pool Properties and,
in the Maximum connections box, type 30.
9. Click OK or Apply and then click Save directly
to master configuration.
Configure the custom property for SQL ServerIn the
navigation tree, click Resources > JDBC > Data sources and,
in the right pane, click the data source that you created in the Create the SQL Server data source for LiveCycle section.
Under Additional Properties, click Custom properties
and then click New.
In the Name box, type useRRASetEquals and
in the Value box, type true.
Click OK or Apply and then click Save directly
to master configuration.
Create SQL Server data source for Rights ManagementFollow
the steps below to create the SQL Server data source for your application server
version.
In the navigation tree, click Resources > JDBC > JDBC Providers and,
in the right pane, click the provider that you created in the Create the SQL Server JDBC provider section.
Under Additional Properties, click Data sources and
then click New.
In the Enter basic data source information pane, set
the following configurations and then click Next:
In the Data source name box, typeLivecycle - SQLServer - RM_DS.
In the JNDI name box, type EDC_DS.
In the Enter database specific properties for the data source pane,
in the Data store helper class name box, replace the existing
entry with the following:
com.ibm.websphere.rsadapter.GenericDataStoreHelper
In the Setup security aliases pane, set the following,
and click Next.
In the Summary pane, click Finish, and then
click Save directly to the master configuration.
Change the statement cache size. Do the following tasks:
In WebSphere Administrative Console, click JDBC > Data sources.
Click the data source you just created and under Additional Properties, click WebSphere Application Server data source properties.
Change the value of the Statement cache size field
to 80.
Click OK or Apply and the click Save directly
to the master configuration.
Configure LiveCycle - SQLServer - RM_DS connection poolsIn the navigation tree, click Resources > JDBC > JDBC Providers and,
in the right pane, click the provider that you created earlier for
WebSphere.
Under Additional Properties, click Data sources and
then select Livecycle - SQLServer - RM_DS.
On the next screen, under Additional Properties, click Connection Pool Properties and,
in the Maximum connections box, type 20.
Click OK or Apply and then click Save directly
to master configuration.
Configure the custom property for SQL ServerIn
the navigation tree, click Resources > JDBC > Data sources and,
in the right pane, click the data source that you created in the Create SQL Server data source for Rights Management section.
Under Additional Properties, click Custom properties and
then click New.
In the Name box, type useRRASetEquals and
in the Value box, type true.
Click OK or Apply and then click Save directly
to master configuration.
Map the Windows login to the LiveCycle database userNote: You must already have a user account
created and associated with your Windows domain.
Note: When you run Configuration Manager, database validation
will fail if you use Windows authentication as the authentication
mode for your database. You can safely ignore this error during
the configuration steps.
Using Microsoft SQL Server
Management Studio, connect to the database server that hosts the
LiveCycle database.
Set the Authentication mode to Windows authentication.
Under Security > Logins, create a new account for
the Windows domain user and select Windows authentication.
Click User Mapping on the Login - New screen and set
the database and default schema for the new user.
Select db_owner as the Database role and click OK.
To
verify that you created the user, expand the LiveCycle database
in the navigation tree and open Security > Users. The new user
is listed there.
Configure integrated security on Windows to make a trusted connection with SQL ServerStart the
application server by using the Windows domain user. If WebSphere Application
Server is running as a service, it should be started by using the Windows
domain user account.
Start the WebSphere Administrative Console by typing http://[host]:[port]/IBM/console in
the URL line of a web browser.
In the navigation tree, click Resources > JDBC > Data Sources and,
in the right pane, click IDP_DS.
In the right pane, under Additional Properties, click Custom Properties,
and on the next screen, click integratedSecurity.
On the next screen, under General Properties, type true in
the Value box.
Click OK or Apply and then click Save directly
to the master configuration.
In the navigation tree, click Resources > JDBC > Data Sources and,
in the right pane, click RM_DS.
In the right pane, under Additional Properties, click Custom Properties,
and on the next screen, click integratedSecurity.
On the next screen, under General Properties, type true in
the Value box.
Click OK or Apply and then click Save directly
to the master configuration.
Open the Services control panel and stop the IBM WebSphere
Application Server <version> - <node> service.
Right-click the service name and click Properties > Log On.
Change the default Log On property from Local
System to the Windows domain user account that you configured in
the Map the Windows login to the LiveCycle database user section
and then restart the service.
On the computer where the application server is installed,
add sqljdbc_auth.dll to the Windows systems path (C:\Windows).
Note: The sqljdbc_auth.dll file is in the same location
as the Microsoft SQL JDBC 3.0 driver installation (default is [InstallDir]/sqljdbc_3.0/enu/auth/x86).
|
|
|
