An upgrade is failing on the automatic site upgrade process for the database due to account credentials not having permission to connect to the SQL DB. Receiving the following error: "Incorrect username or password. Please check your credentials and try again."

Adding the account to the SQL server's security logons with sysadmin privileges allowed for a successful automatic upgrade.

Alternatively, since this was initially performed via manual DB creation, choosing the manual upgrade process and providing SQL scripts to DBAs to perform the upgrade on the SQL back end would also be successful.

---

Problem Cause

The initial DB setup was done via manual SQL scripting, which did not add the Citrix administrator's account to the SQL server's list of security logons.

https://docs.citrix.com/en-us/xenapp-and-xendesktop/current-release/upgrade-migrate/upgrade.html#upgrade-the-databases-and-the-site