Dell PowerEdge R810 Manuel - Page 47
Parcourez en ligne ou téléchargez le pdf Manuel pour {nom_de_la_catégorie} Dell PowerEdge R810. Dell PowerEdge R810 48 pages. Poweredge series
Également pour Dell PowerEdge R810 : Manuel de mise à jour (32 pages), Manuel du propriétaire (42 pages), Manuel du portefeuille (27 pages)
Imprimer la page
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