Our ALM instance is DOWN!!

Question ID: 105991
0
0

This morning we started experiencing issues with ALM. Users were reporting a variety of performance issues, getting kicked out, browsers locking up. While I was in Site Administration anytime I would click on a project I would get "Test Connection" Failed. Server admin rebooted the application server and now when we navigate to the URL we get 503 : Service Unavailable.

i think we are using SQL-Server wtih Windows Authentication.

I see this in the SA logs over and over:

Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.;

Marked as spam
Posted by (Questions: 187, Answers: 13)
Asked on April 9, 2015 5:59 pm
8 views
Answers (1)
0
Private answer

Since you are using SQL-Server with ''Windows-authentication'', the QC server uses a ''service'' called ''HP Application Lifecycle Management'' and that service is being run by a service account user. Yours might be called something like ''qc_admin''.

If the logs indicate that the account qc_admin cannot login to SQL-server, and since EVERYTHING hinges on this user - everything in QC fails!

Check to see if the the service user's Password has expired, or is being blocked by a firewall or in the wrong domain. Perhaps a policy rolled out to increase the domain reach for the user or stricter firewall or port access for that user.

Perhaps some DB policy rolled out to REVOKE the user's SQL-Server or Windows rights - many are REQUIRED for QC to work properly (see QC/ALM Install-Upgrade guide section on Installation Prerequisites/SQL-server user permissions).

Marked as spam
Posted by (Questions: 3, Answers: 472)
Answered on April 9, 2015 6:05 pm
It was the FIREWALL !!!! That user was blocked from getting to the SQL-Server by (seemingly benign) changes made early in the morning to the Firewall settings. D'oh! It all works again, thanks.
( at April 9, 2015 6:07 pm)