ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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


Article ID: 209432


Updated On:


Service Virtualization


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?


Release: 10.4 and later

Component: CA Service Virtualization


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/ file.
  5. Add these lines to the file: (USER must have db_owner to create the tables)


    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.