To map logins to the users in the database, complete the following steps.
- In SQL Server Management Studio, on the toolbar, click New Query.
- Copy and paste the following command set in the Query tab.
USE INOW GO EXEC sp_change_users_login 'update_one', inuser, inuser; EXEC sp_change_users_login 'update_one', inemuser, inemuser; EXEC sp_change_users_login 'update_one', reports, reports;
- On the toolbar, click Execute.