Creating-Updating DB

• Then open query window and execute following stored procedure
  • Transact-SQL

    EXEC sp_change_users_login 'AUTO_FIX','OrphanedUser'

    1	EXEC sp_change_users_login 'AUTO_FIX','OrphanedUser'

SQL 2005 Full version

• Transact-SQL

  Exec sp_change_users_login 'Auto_Fix', 'OrphanedUser',null, 'orphaned'

  1	Exec sp_change_users_login 'Auto_Fix', 'OrphanedUser',null, 'orphaned'

Useful script

Otherwise to associate user to login try the following: