Does IAM supports integrated security for SQL SERVER


Article ID: 101536


Updated On:


CA Application Test Service Virtualization CA Continuous Application Insight (PathFinder) CA Service Virtualization (DevTest / LISA / VSE / Application Test)


IAM (Identity Access Manager) supports SQL SERVER Integrated Security but right now we don’t have an option to configure this out of the box. We have a workaround.  


DEVTEST 10.3 and up


To configure IAM  for Integrated Security, follow the below steps

1.       Choose Embedded database and complete the installation.
2.       Navigate to <VSC_HOME>/IdentityAccessManager/modules and create directory, com/microsoft/sqlserver/jdbc/sqlserverdriver/main
3.       Copy the database driver jar to the above location.
4.       Create a file named module.xml with the contents below in the same directory created in step 2. Replace ="<<REPLACE_WITH_JAR_FILE_NAME>> with name of the jar file.
<?xml version='1.0' encoding='UTF-8'?>
<module xmlns="urn:jboss:module:1.1" name="">
        <resource-root path="<<REPLACE_WITH_JAR_FILE_NAME>>"/>
        <module name="javax.api"/>
        <module name="javax.transaction.api"/>
        <module name="javax.xml.bind.api"/>
5.       Open <VSC_HOME>/IdentityAccessManager/standalone/configuration/standalone.xml and search for “KeycloakDS"”
6.       Replace the datasource with the below content, change the connection url per customer requirement.
<datasource pool-name="KeycloakDS" jndi-name="java:jboss/datasources/KeycloakDS" enabled="true" use-java-context="true">
7.       Next to this datasource tag you will find drivers tag, add the following content.
<driver name="sqlserver" module="">
8.       Start IAM.