Dell PowerEdge R810 - Page 47

Servers: Database consolidation on Dell PowerEdge R810 servers
47
4. Enter the following command, and click Execute:
EXEC sp_change_users_login 'Report';
5. For each user output from the above step, map these
―orphaned‖ users to the appropriate matching SQL Server
login by taking the following steps.
6. Open a query window on the SQL Server 2008 R2 server using
steps 1 through 3 above.
7. For each login you wish to map, enter the following command,
and click Execute:
EXEC sp_change_users_login 'Auto_Fix','SQLLogin';
8. The above command maps the database user ―SQLLogin‖ to
the SQL Server login of ―SQLLogin‖. This procedure assumes
that the database user and SQL Server login have the same
value.
9. To reset the password and enable the account, enter the
following command, and click Execute:
USE [master]
GO
ALTER LOGIN [SQLLogin] WITH PASSWORD=N'Password1'
GO
ALTER LOGIN [SQLLogin] ENABLE
GO
Note: This process assumes that you have already migrated
the applicable database to the new server.