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
Other Resources
Integration Services Error and Message Reference