TechNet
Export (0) Print
Expand All

Transfer Logins Task Editor (Logins Page)

 

Applies To: SQL Server 2016

Use the Logins page of the Transfer Logins Task Editor dialog box to specify properties for copying one or more SQL Server logins from one instance of SQL Server to another. For more information about this task, see Transfer Logins Task.

System_CAPS_ICON_important.jpg Important


When the Transfer Logins task is executed, logins are created on the destination server with random passwords and the passwords are disabled. To use these logins, a member of the sysadmin fixed server role must change the passwords and then enable them. The sa login cannot be transferred.

SourceConnection
Select a SMO connection manager in the list, or click <New connection...> to create a new connection to the source server.

DestinationConnection
Select a SMO connection manager in the list, or click <New connection...> to create a new connection to the destination server.

LoginsToTransfer
Select the SQL Server logins to copy from the source to the destination server. This property has the options listed in the following table:

ValueDescription
AllLoginsAll SQL Server logins on the source server will be copied to the destination server.
SelectedLoginsOnly logins specified with LoginsList will be copied to the destination server.
AllLoginsFromSelectedDatabasesAll logins from the databases specified with DatabasesList will be copied to the destination server.

LoginsList
Select the logins on the source server to be copied to the destination server. This option is only available when SelectedLogins is selected for LoginsToTransfer.

DatabasesList
Select the databases on the source server that contain logins to be copied to the destination server. This option is only available when AllLoginsFromSelectedDatabases is selected for LoginsToTransfer.

IfObjectExists
Select how the task should handle logins of the same name that already exist on the destination server.

This property has the options listed in the following table:

ValueDescription
FailTaskTask fails if logins of the same name already exist on the destination server.
OverwriteTask overwrites logins of the same name on the destination server.
SkipTask skips logins of the same name that exist on the destination server.

CopySids
Select whether the security identifiers associated with the logins should be copied to the destination server. CopySids must be set to True if the Transfer Logins task is used along with the Transfer Database task. Otherwise, the copied logins will not be recognized by the transferred database.

Integration Services Error and Message Reference
Integration Services Tasks
Transfer Logins Task Editor (General Page)
Expressions Page
SMO Connection Manager
Strong Passwords
Security Considerations for a SQL Server Installation

Community Additions

ADD
Show:
© 2016 Microsoft