Installation Stops at Security Passphrases in ALM installation?

  • Questions
  • Installation Stops at Security Passphrases in ALM installation?
Question ID: 108453

I am having the issue where the installation stall during the configuration wizard during while attempting installation. We are installing ALM1 12.55 patch 2 (if this makes a difference), and during the configuration wizard we are stopped once we attempt to enter the security passphrase. We have the correct passphrase from the previous version and are upgrading the qcsiteadmin from the previous version.

Unsure what we are missing that is needed?

Thanks for any assistance and ideas,

Marked as spam
Posted by (Questions: 328, Answers: 20)
Asked on June 20, 2018 2:56 pm
Answers (1)
Private answer

Hello HomerJ,
I have found that in the past when this issue occurred the user accounts weren't correctly provisioned within the DB for either the td user or the tdadmin user. The first thing that needs to be done is run the SQL queries:

EXEC sp_change_users_login 'Report'
EXEC sp_change_users_login 'Update_One', 'td', 'td'
EXEC sp_changedbowner 'td_admin'

*Note the td_admin is the database administrator with the required database privileges and your account may be named differently.

This musty be done after restoring any project schema (to include the qcsiteadmin schema) into the new DB.

These accounts must have the correct permissions as documented within the installation and upgrade guide. If these permissions differ in any way (more or less permissions issues can and more than likely will arise during the installation process. Check these permissions and if necessary delete all the schemas from the new DB and then remove the users and readd them insuring the correct permissions are assigned. In the past this has always resolved the issue I have sen aris,

Hope this helps,

Marked as spam
Posted by (Questions: 0, Answers: 722)
Answered on June 20, 2018 3:08 pm
Thanks for the recommendation. We cleaned up the DB and started fresh insuring the permissions and running the SQL queries above after the restore and then installation completed without issues. Thanks for the recommendations.
( at June 20, 2018 3:11 pm)