Question about DB restore and the role/use of the ”td” user in SQL-Server

  • Questions
  • Question about DB restore and the role/use of the ''td'' user in SQL-Server
Question ID: 105561

I found in HP documentation that when you RESTORE a SQL-Server project DB or qcsiteadmin DB back to SQL-Server used by QC, you must run 2 stored procedures (actually one-liners) to "fix" SQL-Server’s use of the "td" user.:

Update the td user – Do this for EACH migrated project database (AND the qcsiteadmin_db database if you migrated that too)


> 1. Login using ‘sa’ to MS SQL Server’s Query Analyzer, and connect to your
> server.
> 2. Choose the project and run the following commands:
> 3. **EXEC sp_change_users_login ‘Report’**
> 4. You should get the unlinked user (TD).
> 5. **EXEC sp_change_users_login ‘Update_One’, ‘td’, ‘td’**
> 6. This links the "td" user of the QC project database to the same ID of the
> "td" user of the whole SQL server.


Is the "td" user that the two stored proc reference the DB Admin User Name? I want to make sure I have a correct understanding.
This QC instance was setup prior to me joining the company, and the gentlman that did the setup is no longer here.

Marked as spam
Posted by (Questions: 80, Answers: 5)
Asked on August 5, 2014 2:29 pm
Answers (1)
Private answer

The ''td'' user is the ''day-to-day'' user of the project and does various record-level transactions on behalf of the QC-Users.

You also have a ''db-Admin'' user (whatever name your DBA's chose to use) -- this user is he one used when installing QC and used from Site Admin to create or delete projects *and corresponding DB's).

On your NEW DB Server, make sure the ''global'' (SQL-Server instance-level) ''td'' user has appropriate rights and that the ''db-Admin'' user have appropriate rights according to the QC Install Guide SQL-Server DB section of the Before you Install/Prerequisites section.

Marked as spam
Posted by (Questions: 3, Answers: 487)
Answered on August 5, 2014 2:30 pm