Project migration verify issue for QC10 to QC11

  • Questions
  • Project migration verify issue for QC10 to QC11
Question ID: 104965

Attempted a migration of a project from QC10 to QC11 and am getting an error on the verify/repair. I took a DB backup from the QC10 DB SQl DB, restored it to new QC11 SQL DB, copied my repository over and edited my dbid.xml file to match the QC11 setup. Checked and double checked.

Restored the project via siteadmin in QC11 and then attempted verify. Gives me this error:

Database user [td_db_admin] does not have all needed permission on the DB server
No permission to `db_owner'
Failed to execute SQL `use Demo_Migration_Project select is a MEMBER (`db_owner')
AS "result" [Mercury][SQLServer JDBC Driver][SQLServer]The server prinipal "td_db_admin" is not able to access the database "Demo_Migration_Project"

Unable to do a repair as it gives same message.

Marked as spam
Posted by (Questions: 26, Answers: 22)
Asked on April 15, 2013 5:59 pm
Answers (1)
Private answer

I will assume you ran the commands to modify the ownership of the ''td'' user? Two sql commands are listed in the HP upgrade documents, but one is not and it definitely applies to your case.

Within the project in SQL Server Management Studio, run a query against your newly added project database.

These are the two commands that HP gives to modify the ''td'' user:

EXEC sp_change_users_login 'Report'

(This unlinks the ''td'' user.)

EXEC sp_change_users_login 'Update_One', 'td', 'td';

(This links the ''td'' user of the TestDirector database to the same ID as the''td'' user of the
Microsoft SQL Server database.)

A third command needs to be run to modiy the ownership in your circumstance. The command is as follows:

EXEC sp_changedbowner 'td_db_admin'

(This will link your td_db_admin as new database owner and should remove your error message).

Be sure to run that last SQL command for your migrated project database. Within SQL Manager, right click on the database folder for your named project (looks to be Demo_Migration_Project in your case) and do New Query and paste in that third command and execute. After it runs successfully, attempt your verify/repair again for that project within siteadmin.

Marked as spam
Posted by (Questions: 1, Answers: 116)
Answered on April 15, 2013 6:05 pm
Related Link:
( at January 16, 2014 2:14 am)