Quality Center - Failed to create MS SQL project with error 'User td already exists in database'

Googling doesn't help much, fortunately HP trouble shooting site provides the solution.

Problem

When creating a new SQL Server project, the user receives the error message, "User td already existsin database" or "User td already exists in current database." When looking in the Master databaseor Security setting of the SQL Server, the "td" user cannot be seen. The "td" user is created in MS SQL Server the first time a project is created on that database server.

Diagnosis

Diagnosis:There may be a "td" user already in the Model and/or Master databases.

Solution

Manually drop the "td" user from the Model and/or Master databasesManually drop the "td" user from the Model and/or Master databases, and you will be able to successfully create projects without getting the "User td already exists in database" error. 1. Use the Enterprise Manager to open the server and go to "Databases". 2. In the Database list, expand the Model database, and highlight "Users." 3. On the right side, you will see a list of users, delete the "td" user. 4. Repeat steps 2 and 3 for Master database. You should now be able to create a new SQL Server project

Lesson learnt 

Visit HP Support Online -> Troubleshoot when you are having problem with HP products.