Configuring TDM Portal to use Integrated Security when connecting to the GTREP Repository Database on SQL Server
search cancel

Configuring TDM Portal to use Integrated Security when connecting to the GTREP Repository Database on SQL Server

book

Article ID: 280294

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

What steps are required for configuring TDM Portal to connect to the GTREP repository using a Windows account?

Environment

TDM Portal 4.10 and greater

Resolution

Before you begin to configure TDM Portal to use a Windows account to connect to the gtrep repository database, verify with your SQL Server DBA that the gtrep database has been configured to use Integrated Security, and verify the proper Windows account to use to connect to the database.

  1. To enable Integrated Security for TDM Portal, first, we need to configure the CA Test Data Manager Portal service to run under the same domain account used to log into the gtrep database.
    1. Open the Windows Services control panel and stop the CA Test Data Manager Portal service.
    2. Right-click the CA Test Data Manager Portal service and click Properties.
    3. Click the "Log On" tab in the Properties dialog.
    4. Select the "This account" option, and enter the domain account that you want to be used.
    5. Enter the password for this user, and confirm the password. Click OK

  2. Next, we need to modify the GTREP database configuration in the application.properties file, to use Integrated Security.
    1. Open a Windows File Explorer and browse to the CA Test Data Manager Portal installation directory.
      By default, this is the C:\Program Files\CA\CA Test Data Manager Portal\conf directory.
    2. Open the file application.properties file in a text editor of your choice.
    3. Append integratedSecurity=true to the datasource.url  property.
      For example: spring.datasource.url =jdbc:sqlserver://<hostname>:1433;database=gtrep;trustServerCertificate=true;integratedSecurity=true
    4. Comment out or delete the values in the datasource.username and datasource.password fields.
      For example: spring.datasource.username=
                            spring.datasource.password=

  3. Ensure that the path to the mssql-jdbc_auth-12.4.2.x64.dll driver is added to the Windows System PATH environment variable.
    By default, the path is C:\Program Files\CA\CA Test Data Manager Portal\service\lib
    For example:


  4. In a Windows File Explorer, navigate to the %ProgramData%\CA\CA Test Data Manager Portal\log directory, and clear out all the existing logs.

  5. Restart the CA Test Data Manager Portal Service.

  6. Go back to the  %ProgramData%\CA\CA Test Data Manager Portal\log directory, and check the TDMSchemaManagementStartup.log and the startup.log for any errors.
    If TDM Portal was able to connect to the gtrep2 database, you should see 20 log (text) files created in the logs directory. It could take several minutes of all the logs to be created.

If you noticed that the connection failed, or see any errors, please go to the Broadcom Support Portal and open a new support case detailing the problem and error you are seeing.
Providing a copy of the logs will help the Support engineer troubleshoot the problem further.

Additional Information

Powered by Wolken Software