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

October 1, 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

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'