Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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.
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
Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayTraining
Certification
Microsoft Certified: Azure Database Administrator Associate - Certifications
Administer an SQL Server database infrastructure for cloud, on-premises and hybrid relational databases using the Microsoft PaaS relational database offerings.
Documentation
Server configuration: Agent XPs - SQL Server
Discover how to use the Agent XPs option to enable SQL Server Agent extended stored procedures. View an example that uses this option.
Maintenance Plan (Design Tab) - SQL Server
Maintenance Plan (Design Tab)
sp_delete_maintenance_plan (Transact-SQL) - SQL Server
sp_delete_maintenance_plan deletes the specified maintenance plan.