Maintenance Plan (Manage Connections)
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
See also
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for