Dell PowerEdge R810 매뉴얼 - 페이지 47
{카테고리_이름} Dell PowerEdge R810에 대한 매뉴얼을 온라인으로 검색하거나 PDF를 다운로드하세요. Dell PowerEdge R810 48 페이지. Poweredge series
Dell PowerEdge R810에 대해서도 마찬가지입니다: 업데이트 매뉴얼 (32 페이지), 소유자 매뉴얼 (42 페이지), 포트폴리오 매뉴얼 (27 페이지)
페이지 인쇄
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