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

  

  

  

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>