Upgrade to 14.6 fails with error “Could not validate the given settings”
Article ID: 442608
Updated On:
Products
Issue/Introduction
During 14.6 upgrade attempt, the following error appears:
“Could not validate the given settings”
Environment
Client Automation 14.6
Cause
While checking TRC_Inst2_ITRM.log log, the following message is seen:
3/31/2026 12:52:08 PM.0969|5644:|mssql: finduser() ...
3/31/2026 12:52:08 PM.0985|5644:|mssql: finduser() ... query: if not exists (select * from master..syslogins where loginname = 'ca_itrm') RAISERROR ('user not found', 16, 1)
3/31/2026 12:52:09 PM.0001|5644:|mssql: executeSP() ...
3/31/2026 12:52:09 PM.0016|5644:|mssql: SQL: if not exists (select * from master..syslogins where loginname = 'ca_itrm') RAISERROR ('user not found', 16, 1)
3/31/2026 12:52:09 PM.0032|5644:|mssql: executeSP failed
On an machine that the upgrade was successfully performed, this same function call works:
5/26/2026 10:05:22 AM.0829|4916:|mssql: finduser() ...
5/26/2026 10:05:22 AM.0831|4916:|mssql: finduser() ... query: if not exists (select * from master..syslogins where loginname = 'ca_itrm') RAISERROR ('user not found', 16, 1)
5/26/2026 10:05:22 AM.0834|4916:|mssql: executeSP() ...
5/26/2026 10:05:22 AM.0836|4916:|mssql: SQL: if not exists (select * from master..syslogins where loginname = 'ca_itrm') RAISERROR ('user not found', 16, 1)
5/26/2026 10:05:22 AM.0840|4916:|mssql: executeSP() OK
Resolution
The root cause of this error is that the OS user running the installer has limited permissions on the target DB, the user can remotely login and perform changes in the database (create or delete tables), but is not able to see the DB logins, which causes the mentioned issue.
In order to avoid any error, the recommendation is to grant “sysadmin” role to this OS user, directly in the DB:
After the upgrade ends, the sa permission of this OS user can be revoked, since it's not used anymore.
Feedback
