Share via


SMO Connection Manager Editor

Use the SMO Connection Manager Editor to configure a SQL Server connection for use by the various tasks that transfer SQL Server objects.

To learn more about the SMO connection manager, see SMO Connection Manager.

Options

  • Server name
    Type the name of the SQL Server instance or select the server name from the list.

  • Refresh
    Refresh the list of available SQL Server instances that can be detected on the network.

  • Use Windows Authentication
    Use Windows Authentication to connect to the selected SQL Server instance.

  • Use SQL Server Authentication
    Use SQL Server Authentication to connect to the selected SQL Server instance.

  • User name
    If you have selected SQL Server authentication, enter the SQL Server user name.

  • Password
    If you have selected SQL Server authentication, enter the password.

  • Test Connection
    Test the connection as configured.

See Also

Concepts

Integration Services Error and Message Reference