What steps are required to use Windows authentication (Integrated Security) to allow proper connection to the SQL Server external databases for IAM, Enterprise dashboard, and Registry?
Service Virtualization 10.8
When configuring DevTest to use external databases, the DBA must create three separate databases/schemas. One database/schema for the following components:
The same Windows Account can be used to access all three databases.
When using a Windows Account (integrated security), the Windows services for the DevTest Components, must be configured to start under the same Windows Account used to access the external SQL Server databases. It's recommended to configure the DevTest Identity Access Manager service, and the DevTest Enterprise Dashboard service to start Automatically. All other DevTest services should be configured to use the Automatic (Delayed Start).
iam.db.vendor=mssql
iam.db.url=jdbc:sqlserver://<hostname>:<port>;databaseName=<IAM database name>;integratedSecurity=true;encrypt=false;trustServerCertificate=true
iam.db.user=<host or domain name>\<username>
iam.db.password=<leave this property blank>
dradis.db.internal.enabled=falseFor the MS SQL Server connection:
dradis.db.url=jdbc:sqlserver://<hostname>:<port>;databaseName=<Enterprise Dashboard database name>;integratedSecurity=true;encrypt=false;trustServerCertificate=true
dradis.db.user=<host or domain name>\<username>
dradis.db.password=<leave this property blank>
lisadb.internal.enabled=falseFor the MS SQL Server connection:
lisadb.pool.common.url=jdbc:sqlserver://<hostname>:<port>;databaseName=<Registry database name>;integratedSecurity=true;encrypt=false;trustServerCertificate=true
lisadb.pool.common.user=<host or domain name>\<username>
lisadb.pool.common.password=<leave this property blank>
After the IAM, Enterprise Dashboard, and Registry services are running, the remaining DevTest components can be started as you normally would do.
NOTE: When running multiple DevTest servers, all servers need to have a copy of the mssql-jdbc_auth-8.2.0.x64.dll file in the %DevTest_Home%\jre\bin directory. Otherwise, the connection to the Registry will time out due to the database connection failing.
Note: For your convenience, the required authentication DLL files have been attached to this KB.