user must be a valid user in the current database

• Carl Ranquist

  Old Hand

  Points: 333

  More actions

  June 17, 2003 at 8:38 am

  #105828

  Bummer! This threw me off because the error said "Server user 'webuser' is not a valid user in database 'Inventory'". SQL Server BOL states in the section for sp_change_users_login, "user must be a valid user in the current database", so I assumed this had to be the wrong answer. Tough one...

  
  Carl Ranquist
  Data Services Manager
  MTD Marketing, Inc.

• wmp789

  SSCarpal Tunnel

  Points: 4354

  More actions

  June 18, 2003 at 11:02 am

  #461952

  What happened here is that the database user is out of sync with the server login, which gives the error '... not a valid user...'.

  'sp_change_users_login' should fix this broken link.