Appendix h. transferring sql server logins, Appendix h – Dell R810 User Manual

Page 46

Advertising
background image

Servers: Database consolidation on Dell PowerEdge R810 servers


46

Appendix H. Transferring SQL Server logins

In this appendix, we give detailed instructions on transferring SQL
Server logins from a SQL Server 2000 server to SQL Server 2008
R2. For information about transferring logins when using Windows
authentication, see

Appendix G

.

Transferring logins

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

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 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
2008 R2 server, and click Connect.

3.

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

Advertising