Dell POWEREDGE R515 Bedienungsanleitung PDF herunterladen (Seite 43)

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

APPENDIX I – TRANSFERRING SQL SERVER LOGINS

In this appendix, we give detailed instructions on transferring SQL

Server logins from a SQL Server 2000 or SQL Server 2005 machine to a

virtual machine running SQL Server 2008 R2. For information about

transferring logins when using Windows authentication, see Appendix

1. On the virtual machine running SQL Server 2008 R2, log into

Windows, and 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 the relevant older

server, either your SQL Server 2000 machine or your SQL Server

2005 machine, and click Connect.

3. Select ViewObject Explorer Details to bring up the Object

Explorer Details tab.

4. In the Object Explorer pane, expand the Security folder, and

highlight the Logins folder.

5. Add the Login Type column to the display by right-clicking the

column-header area and selecting Login Type. Now SQL Server

Logins appear as Login Type 2. Optionally, use the column headers

to sort by Default Database, or the Filter button to find only logins

that you are interested in migrating.

6. Using the standard Windows multi-select key combinations (Ctrl

key or Shift key), highlight the logins you are interested in

migrating.

7. Right-click the highlighted logins, and select Script Login

asCreate ToNew Query Editor Window.

8. On the Connect to Database Engine screen, change the Server

name to your SQL Server 2008 R2 virtual server, and click

Connect.

9. Click Execute to run the resulting script.

Mapping transferred logins to database users

After transferring SQL Server logins from server to server, you must

map those logins to the database users that you migrated during the

restore process.

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

Keine Kommentare

Dell POWEREDGE R515 Bedienungsanleitung Seite 43