Need Steps for Configuring IAM to use an External SQL Server Database

book

Article ID: 209432

calendar_today

Updated On:

Products

Service Virtualization

Issue/Introduction

We upgraded to version 10.6 and are trying to set up IAM for the first time on SqlServer. What are the necessary steps we need to take in order to get this accomplished?

Environment

Release: 10.4 and later

Component: CA Service Virtualization

Resolution

Here is what you need to do to change your IAM to use a SQL Server database instead of the Embedded database:

  1. Your DBA will have to create a new database without any tables for IAM.
  2. Create a new folder DEVTEST_HOME/IdentityAccessManager/database/drivers     (note: optional, this is not in the docs, it is what I do.)
  3. Copy file DEVTEST_HOME/lib/dradis/sqljdbc4-4.0.jar to folder DEVTEST_HOME/IdentityAccessManager/database/drivers.
  4. Update DEVTEST_HOME/IdentityAccessManager/iam.properties file.
  5. Add these lines to the file: (USER must have db_owner to create the tables)

    iam.db.vendor=mssql
    iam.db.url=jdbc:sqlserver://[HOSTNAME]:1433;databaseName=[DatabaseName]
    iam.db.user=[USER]
    iam.db.password=[PASSWORD]
    iam.db.jdbc.driver.class=com.microsoft.sqlserver.jdbc.SQLServerDriver
    iam.db.jdbc.driver.path=${IAM_HOME}/database/drivers/sqljdbc4-4.0.jar

    Note: If you are using Windows Integrated Security the URL should look like: jdbc:sqlserver://[HOSTNAME]:1433;integratedSecurity=true;databaseName=[DatabaseName].  

    when using Integrated Security, do not comment out  'iam.db.password'  , just provide a dummy password  

     - Download sqljdbc_auth.dll from any Microsoft site. 
    - Copy sqljdbc_auth.dll into the java library classpath:  (i.e. java.library.path = c:\program files\ca\devtest\jre\bin => Identified based on server.log)

    6. Stop all DevTest components.
    7. Delete all the log files in /opt/CA/DevTest10.5/IdentityAccessManager/standalone/log
    8. Start all DevTest components.
    9. Login to IAM to verify.

 

 

where DEVTEST_HOME is the home folder of where DevTest is installed.

If the variable ${IAM_HOME} is not recognized, replace it with the direct patch of DEVTEST_HOME.

where sqljdbc4-4.0.jar is the SQL Server JDBC driver we deliver with DevTest.

Additional Information

There is no version of the integrated authentication dll that will work from Linux. Currently integrated authentication is Windows only.  Will have to do Server Authentication only.