Creating-Updating DB
- Then open query window and execute following stored procedure
-
1EXEC sp_change_users_login 'AUTO_FIX','OrphanedUser'
-
SQL 2005 Full version
-
1Exec sp_change_users_login 'Auto_Fix', 'OrphanedUser',null, 'orphaned'
Useful script
1 2 3 4 5 |
CREATE LOGIN OrphanedUser WITH PASSWORD = 'orphaned', CHeck_Policy= OFF |
Otherwise to associate user to login try the following:
1 |
CREATE USER OrphanedUser FOR LOGIN OrphanedUser |