td « BrakertechBrakertech

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

posted this in MSSQL, Windows on October 1st, 2010

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

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’.

Next you need to assign user td in your busted database the same permissions and the login user td. To do that run this script:

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

1	EXEC sp_change_users_login 'Update_One', 'td', 'td'

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

posted this in MSSQL, Software, Windows on September 30th, 2010

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)

[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 in your qc admin table. This table is sometimes labeled ‘MercuryQC_SA_DB’.

Depending on your database you may need to replace the name right after “Use”:

use MercuryQC_SA_DB
GRANT ALL ON td.LOGIN_SESSIONS to td
GRANT ALL ON td.PARAMS to td
GRANT ALL ON td.PROJECT_SESSIONS to td
GRANT ALL ON td.PROJECTS to td
GRANT ALL ON td.SEQUENCES to td
GRANT ALL ON td.SESSION_LICENSE to td
GRANT ALL ON td.SESSIONS_HISTORY to td
GRANT ALL ON td.SESSION_LICENSE_HISTORY to td
GRANT ALL ON td.APPSERVERS to td
GRANT ALL ON td.USERS to td
GRANT ALL ON td.CACHE to td
GRANT ALL ON td.USERS_PROJECTS to td
GRANT ALL ON td.USERS_PROJECTS_TEMP to td
GRANT ALL ON td.MESSAGES to td
GRANT ALL ON td.GROUPS to td
GRANT ALL ON td.REPOSITORY to td
GRANT ALL ON td.ROLES to td
GRANT ALL ON td.USERS_GROUPS to td
GRANT ALL ON td.USERS_ROLES to td
GRANT ALL ON td.CLUSTERED_RESOURCE to td
GRANT ALL ON td.ADMIN to td
GRANT ALL ON td.AUDIT_LOG to td
GRANT ALL ON td.AUDIT_PROPERTIES to td
GRANT ALL ON td.DBSERVERS to td
GRANT ALL ON td.DOMAINS to td
GRANT ALL ON td.LOCKS to td
GO

use MercuryQC_SA_DB

GRANT ALL ON td.LOGIN_SESSIONS to td

GRANT ALL ON td.PARAMS to td

GRANT ALL ON td.PROJECT_SESSIONS to td

GRANT ALL ON td.PROJECTS to td

GRANT ALL ON td.SEQUENCES to td

GRANT ALL ON td.SESSION_LICENSE to td

GRANT ALL ON td.SESSIONS_HISTORY to td

GRANT ALL ON td.SESSION_LICENSE_HISTORY to td

GRANT ALL ON td.APPSERVERS to td

GRANT ALL ON td.USERS to td

GRANT ALL ON td.CACHE to td

GRANT ALL ON td.USERS_PROJECTS to td

GRANT ALL ON td.USERS_PROJECTS_TEMP to td

GRANT ALL ON td.MESSAGES to td

GRANT ALL ON td.GROUPS to td

GRANT ALL ON td.REPOSITORY to td

GRANT ALL ON td.ROLES to td

GRANT ALL ON td.USERS_GROUPS to td

GRANT ALL ON td.USERS_ROLES to td

GRANT ALL ON td.CLUSTERED_RESOURCE to td

GRANT ALL ON td.ADMIN to td

GRANT ALL ON td.AUDIT_LOG to td

GRANT ALL ON td.AUDIT_PROPERTIES to td

GRANT ALL ON td.DBSERVERS to td

GRANT ALL ON td.DOMAINS to td

GRANT ALL ON td.LOCKS to td

And How did we get all . . . → Read More: SELECT permission denied on object ‘USERS’, database ‘qcsiteadmin_db’, owner ‘dbo’

Howto: Fix Login failed for user ‘td’

posted this in MSSQL, Security, Software, Windows on July 20th, 2010

[Mercury][SQLServer JDBC Driver][SQLServer]Login failed for user ‘td’

Basically this error means that the password that quality center is trying to use for user ‘td’ in your MSSQL database doesn’t match whatever is in the database.

How did I fix this?

I installed Wireshark and captured the traffic on the server that Quality Center was installed . . . → Read More: Howto: Fix Login failed for user ‘td’

Brakertech

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

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

Search Brakertech

dEFENSE

Hacking

Security

Brakertech

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

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

Howto: Fix Login failed for user ‘td’

Search Brakertech

dEFENSE

Hacking

Tags

Security