Appendix g. transferring windows logins – Dell R810 User Manual
Page 45
Servers: Database consolidation on Dell PowerEdge R810 servers
45
Appendix G. Transferring Windows logins
In this appendix, we provide detailed instructions for migrating
transferring Windows-based logins from a SQL Server 2000 server
to SQL Server 2008 R2 in an Active Directory environment. For
information about transferring logins when using SQL Server
authentication, see
1.
On the SQL Server 2008 R2 server, log into Windows, then
open SQL Server Management Studio by selecting Start | All
Programs | Microsoft SQL Server 2008 R2 November CTP |
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
2000 server, 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
then 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 as |
CREATE To | New Query Editor.
8.
On the Connect to Database Engine screen, change the Server
name to your SQL Server 2008 R2 server, and click Connect.
9.
Click Execute to run the resulting script.