When upgrading to 10.6 or 10.7 version and trying to set up DEVTEST to use an External SQL Server Database (with integrated Security), what are the necessary steps you need to take?
N/A
Release: 10.6 and later
Component: CA Service Virtualization
Here is what you need to do to change your IAM or DEVTEST to use a SQL Server database instead of the Embedded database:
iam.properties file
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 for 10.6
iam.db.jdbc.driver.path=${IAM_HOME}/database/drivers/mssql-jdbc-8.2.0.jre8.jar for 10.7
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
5. For Enterprise Dashboard, the jar file is available in DEVTEST_HOME/lib/dradis/sqljdbc4-4.0.jar folder or mssql-jdbc-8.2.0.jre8.jar (10.7).
Here is an example of database details for the Enterprise Dashboard: (dradis.properties)
## ==================================================================================
## MS SQL Server using Windows Authentication
## ==================================================================================
dradis.db.pool.dradis.driverClass=com.microsoft.sqlserver.jdbc.SQLServerDriver
dradis.db.pool.dradis.url=jdbc:sqlserver://ABC04W7A.ca.com:1433;databaseName=ED801DB;integratedSecurity=true
dradis.db.pool.dradis.user=TANT-A01\\ABC04
dradis.db.pool.dradis.password=<password>
6. For Registry, the jar file is available in DEVTEST_HOME/lib/Shared sqljdbc4-4.0.jar or or mssql-jdbc-8.2.0.jre8.jar (10.7).
Details for the Registry: (site.properties)
## ==================================================================================
## MS SQL Server using Windows Authentication
## ==================================================================================
lisadb.pool.common.driverClass=com.microsoft.sqlserver.jdbc.SQLServerDriver
lisadb.pool.common.url=jdbc:sqlserver://ABC4W7A:1433;databaseName=REG801DB;integratedSecurity=true
lisadb.pool.common.user=TANT-A01\\ABC04
lisadb.pool.common.password=<password>
The dll you use depends on the JVM you are running, 32-bit or 64-bit. The dll needs to be copied to DEVTEST_HOME/jre/bin folder
7. Stop all DevTest components.
8. Delete all the log files in DEVTEST_HOME/IdentityAccessManager/standalone/log and DEVTEST_HOME/lisatmp10.x folder
9. Start all DevTest components.
10. Login to IAM ,ED and Portal 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/mssql-jdbc-8.2.0.jre8.jar are the SQL Server JDBC drivers we deliver with DevTest.
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.