We upgrade TDM Portal to 4.10.219.0, but we are getting an error for all our SQL Server connection profiles in TDM Portal.
Error: The server replied: Failed to obtain JDBC Connection; Login failed for user 'AD1\XXXXXXXXX. ClientConnectionId:b7248727-nnnn-4654-nnnn-1708nn5n66nn
We tried reverting to the TDM 4.10 GA build, which was working before the upgrade, and the connections are failing for this release as well. We are trying to connect to SQL Server 2016 with Integrated Security.
Release : TDM Portal 4.10.xxx or newer
After upgrading the TDM Portal, the "CA Test Data Manager Portal" Windows service is rebuilt, which causes the service to configured to start under the Local System Account.
Since the TDM Services are now running as the Local System, and not the proper service account, the connections used for the integrated security to the SQL Server connections are failing.
If your implementation of the "CA Test Data Manager Portal" Windows service should be running under a service account, you will need to: