| || |
QC DB Password Change Problem !!!
=> Can anybody guide me that what will be the impact of changing the password of QC DB externally by the database team on QC functionality?
=> Do we must need to change the password of Qc system user accordingly after changing the DB password externally (Not from QC interface)?
=> Is it mandatory to change the QC DB password from QC interface only ?
=> Can anybody differentiate that what is the difference between "QC System User" and the "DB System User(The Owner of DB)" ?
=> What are the HP recommendation in this regard that how we change the QC password, becuase due to security reasons, DB operation team will change the password Continuously
Waiting for a detailed response :-)
Re: QC DB Password Change Problem !!!
As per the description, the QC DB user password has changed or needs to be changed. Let me give you a picture of this.
QC has two users (the td user and the DB admin user which you use as the DB Admin while installing QC). The td user password must NOT be changed. By default it is tdtdtd and it should not be changed (even as per HP recommendations). When you are installing QC, the pllace where you give the database details, if you go to show advanced options, you will have a QC user password which will be entered by default (you dont have to enter it yourself) (This is for SQL as database and SQL authentication).
Now we talk about the DB admin user. This is the user which has privileges to create, update and delete databases. You can use the sa user or for security reasons I believe the DB people must have created one user as the DB admin user for you with these permissions. The password for this can be changed from the dB side. Now once this is done, you need to login to Site Admin. Here go to DB servers tab. For teh connection string, you haveto chnage the DB Admin user password there as well. Once this is done, ping and see if ping finishes successfully. Next in the projects also you have to ping and check. If pinging projects fails, then let me know, I will help you out in remove and restore the projects.
Let me know if you have questions.