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


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' 

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.