Export (0) Print
Expand All

Connect to Server (Login Page) Integration Services

Use this tab to view or specify the following options when connecting to Microsoft SQL Server 2005 Integration Services (SSIS).

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 2005 Compact Edition, 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 2005 Compact Edition, 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.

ms180068.note(en-US,SQL.90).gifNote:
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.

Remember password

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

Connect

Connect to the server selected above.

Options

Click to change the dialog and hide the additional server connection options, such as remembering the password.

Community Additions

ADD
Show:
© 2014 Microsoft