Dell PowerEdge R810 Handmatig - Pagina 47
Blader online of download pdf Handmatig voor {categorie_naam} Dell PowerEdge R810. Dell PowerEdge R810 48 pagina's. Poweredge series
Ook voor Dell PowerEdge R810: Handleiding bijwerken (32 pagina's), Gebruikershandleiding (42 pagina's), Portfolio Handleiding (27 pagina's)
Pagina afdrukken
Servers: Database consolidation on Dell PowerEdge R810 servers
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.
47