Silent TDM Portal patch install with SQL Server integrated Security

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

The interactive installer has a tick box for integrated security for SQL Server login.
How can this be set when doing a silent install of a patch.

Environment

Release : 4.9

Component : TDM Web Portal

Resolution

TDM Portal integrated security for SQL Server is configured in application.properties: 
spring.database.url=jdbc:sqlserver://localhost:1433;database=gtrep;integradedSecurity=true;
The integratedSecurity=true in application.properties will be preserved when doing a patch install.

But if the Logon account of the CA TDM Portal Windows service is set to a specific user, then this is not preserved.
The Windows "sc" command can be used to stop and also to configure the service with a logon account.

Additional Information

A silent patch install can be done by using the /qn MSI option: 
"setup_CA Test Data Manager Portal4.9.xxx.x.exe" /qn

Download the latest patch from: 
https://support.broadcom.com/external/content/release-announcements/Test-Data-Manager-TDM-Patches/16649