42
Migrating to a Dell PowerEdge R515 server from two legacy database servers
APPENDIX H – TRANSFERRING WINDOWS LOGINS
In this appendix, we provide detailed instructions for transferring
Windows-based logins from a SQL Server 2000 or SQL Server 2005
machine to SQL Server 2008 R2 in an Active Directory or Windows
login-only environment. For information about transferring logins
when using SQL Server authentication, see Appendix I.
1. On the virtual machine running SQL Server 2008 R2, log into
Windows, then open SQL Server Management Studio by selecting
StartAll ProgramsMicrosoft SQL Server 2008 R2SQL 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 ViewObject 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 in the Object Explorer Details pane and
selecting Login Type. Now Windows Logins appear as Login Type
0. Optionally, use the column headers to sort by Default
Database, or use 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
asCreate ToNew Query Editor.
8. On the Connect to Database Engine screen, change the Server
name to your SQL Server 2008 R2 virtual machine, and click
Connect.
9. Click Execute to run the resulting script.
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Komentarze do niniejszej Instrukcji