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

Other Resources

Integration Services Error and Message Reference

Help and Information

Getting SQL Server 2005 Assistance