Dell POWEREDGE R515 Manual de usuario descargar pdf (Pagina 44)

Migrating to a Dell PowerEdge R515 server from two legacy database servers

NOTE: This process assumes that you have already migrated

the applicable database to the new server.

1. On the SQL Server 2008 R2 virtual server, log into Windows. Then

open SQL Server Management Studio by selecting StartAll

ProgramsMicrosoft SQL Server 2008 R2SQL Server

Management Studio.

2. On the Connect to Server screen, select Database Engine for the

server type, enter the computer name of your SQL Server 2008 R2

virtual server, and click Connect.

3. Right-click the relevant database, and select New Query.

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:

a. Open a query window on the SQL Server 2008 R2 virtual

server using steps 1 through 3 above.

b. For each login you wish to map, enter the following

command, and click Execute:

EXEC sp_change_users_login

'Auto_Fix','SQLLogin';

c. 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.

6. To reset the password and enable the account, enter the

following command, and click Execute:

USE [master]

ALTER LOGIN [SQLLogin] WITH

PASSWORD=N'Password1'

ALTER LOGIN [SQLLogin] ENABLE

1 2 ... 39 40 41 42 43 44 45

Sin comentarios

Dell POWEREDGE R515 Manual de usuario Pagina 44