To Prepare SQL Server for Use with Identity Manager

1. Install Microsoft SQL Server or confirm the connection to a SQL Server installation.

2. Create the database. To do this:

   1. Copy the create_waveset_tables.sqlserver script to a temporary location. This script is located in the db_scripts directory in the Identity Manager installation package, and also in the idm\sample directory if Identity Manager is already installed.

   2. Modify the create_waveset_tables.sqlserver script to change the login password.

      ---

      Note –

      Your database administrator may want to modify the script to meet site-specific requirements for backup, replications, disk allocation, distribution, or other considerations.

      ---

   3. Create the new tables by executing the create_waveset_tables.sqlserver script, located on the installation CD; for example:

      osql -E -i PathToFile\create_waveset_tables.sqlserver

      ---

      Note –

      You must have privileges to create databases and logins.

      ---

3. Download the Microsoft SQL Server 2005 Driver for JDBC.

   ---

   Note –

   Identity Manager version 8.1 supports SQL Server 2008 using the SQL Server 2005 JDBC drivers.

   ---

   1. Go to the Microsoft downloads website. http://www.microsoft.com/downloads

   2. In the Search for a Download area, enter “SQL Server JDBC” in the keywords field, and then click Go.

   3. Download the correct version of the driver for your installation.

      Later, during the Identity Manager installation process, you will install the SQL Server driver to the $WSHOME/WEB-INF/lib directory on your application server.

      See Notes on Configuring Databases and Downloading Supporting JAR Files for more information.