Share via


Connect to Server (Integration Services)

Use this dialog to view or specify options when connecting to Microsoft Integration Services.

Options

  • Server type
    When registering a server from Object Explorer, select the type of server to connect to: Database Engine, Analysis Services, Reporting Services, SQL Server Compact 3.5 SP1, or Integration Services. The rest of the dialog shows only the options that apply to the selected server type. When registering a server from Registered Servers, the Server type box is read-only, and matches the type of server displayed in the Registered Servers component. To register a different type of server, select Database Engine, Analysis Services, Reporting Services, SQL Server Compact 3.5 SP1, or Integration Services from the Registered Servers toolbar before starting to register a new server.

  • Server name
    Select the server to connect to. The server instance last connected to is displayed by default.

    Note

    Do not use <servername>\<instancename>, because SSIS does not support multiple instances on a computer.

  • Authentication
    Only Microsoft Windows Authentication is available for SSIS. Windows Authentication mode allows a user to connect through a Windows user account.

  • User name
    This option is not available because only Windows Authentication is available for SSIS.

  • Password
    This option is not available because only Windows Authentication is available for SSIS.

  • Connect
    Click to connect to the server selected above.

  • Options
    Click to display additional server connection options, such as registering a server and remembering the password.