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

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

Your email address will not be published. Required fields are marked *

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