Attempting an upgrade our ALM version and encountering issues during the security stage?
Question ID: 108482

We are attempting to upgrade our current version of ALM but run the installation it hangs at the security phrase sections and after entering the correct passphrase we never get the next button to become active. We have restored the qcsiteadmin_db DB schema to the new DB server prior to attempting installation o we have the correct DB. What are we missing??


Marked as spam
Posted by (Questions: 379, Answers: 35)
Asked on July 10, 2018 3:41 pm
Answers (1)
Private answer

Hi HomerJ,
I would recommend that first you check that the td user and siteadmin user accounts exist within the new DB and are granted the correct roles and permissions (td should be public only and the siteadmin should be dbcreator, securityadmin, serveradmin, public, and sysadmin while installing/upgrading....note of using the SA account then sysadmin and public will suffice and more is not always good as in this case more permissions and roles will cause issues the same as not enough permissions and roles.). Then next I would suggest that you run the ownership queries from the installation guide that will change the owenership from the project schemas associated td account to the new DB's td account. You will also need to be using a local admin account on the application server to install so as to provide all the correct associated read/write permissions to the needed folders within the application server's operating system and make changes as needed. IF these are good you should then be able to install without error.

I have seen in the past where we had to delete the user accounts and recreate them on the DB and restore the project schema again as prior attempts to create the accounts resulted in residual permissions and issues that removal and recreation corrected.

Hope this helps,

Marked as spam
Posted by (Questions: 0, Answers: 770)
Answered on July 10, 2018 3:54 pm
We had to remove and recreate the accounts as suggested and then were able to complete the installation without issue, Thanks for the suggestions.
( at July 10, 2018 3:55 pm)

Welcome back to "EyeOnTesting" brought to you by Orasi Software, Inc.

Scroll to Top