Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server
Use the Manage Connections dialog box to specify the properties of connections used by maintenance plans. When you create a maintenance plan, a local connection to the server where you created the plan is created. Use this connection to create tasks that perform work on this local connection. When needed, use the Manage Connections dialog box to add them. When additional connections are configured, they appear in the connections box for each task.
Options
Server
The server instance.
Authentication
Indicates whether the connection is made with Windows Authentication or SQL Server Authentication.
Important
The package is stored in the msdb database with its ProtectionLevel set to ServerStorage, so when SQL Server Authentication is used, the password will not be encrypted in msdb. You can use SQL Server Authentication as long as msdb is secured, but using Windows Authentication is recommended