Server user ‘td’ is not a valid user in database

Error:

Messages: Failed to Get Projects Properties; Failed to get projects properties; Failed to save projects properties; Cannot build directory item for key ‘…… …….. [Mercury][SQLServer JDBC Driver][SQLServer]Server user ‘td’ is not a valid user in database

If this is a SQL 2000 database detach and reattach with enterprise manager and make the owner ‘sa’.

. . . → Read More: Server user ‘td’ is not a valid user in database

in TD Tables Struct Dir; [Mercury][SQLServer JDBC Driver][SQLServer]Invalid object name ‘SEQUENCES’.;

How to fix

Failed to determine structure in TD Tables Struct Dir; [Mercury][SQLServer JDBC Driver][SQLServer]Invalid object name ‘SEQUENCES’.

This error may occur with Mercury Quality Center 9.0 if you move a project between databases.

The fix:

1. Detach the database 2. Reattach the database and make the owner ‘sa’

SELECT permission denied on object ‘USERS’, database ‘qcsiteadmin_db’, owner ‘dbo’

How to resolve this error:

[Mercury][SQLServer JDBC Driver][SQLServer]SELECT permission denied on object ‘USERS’, database ‘qcsiteadmin_db’, owner ‘dbo’.; Stack Trace: java.sql.SQLException: [Mercury][SQLServer JDBC Driver][SQLServer]SELECT permission denied on object ‘USERS’, database ‘qcsiteadmin_db’, owner ‘dbo’. at com.mercury.jdbc.base.BaseExceptions.createException(Unknown Source) at com.mercury.jdbc.base.BaseExceptions.getException(Unknown Source)

The reason this error is occurring is because user td does not have rights to the tables . . . → Read More: SELECT permission denied on object ‘USERS’, database ‘qcsiteadmin_db’, owner ‘dbo’