Share via

SMO Connection Manager Editor

  • Article

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

Integration Services Error and Message Reference