I have changed the SQL account password but my all backups have failed. How do I update the new password manager connection in the maintenance plan from the backup?
Sql-server – how to update new password in maintenance plan
sql serversql-server-2016
Related Question
- Sql-server – Deploy SQL Server Backup Maintenance Plan in multi-tenant environment
- Sql-server – Maintenance plan fails on non-existent database
- Sql-server – Adding new databases to existing maintenance backup plan
- Sql-server – Cannot see new drive in SSMS maintenance wizard
- Sql-server – SSMS 2016 Maintenance Plan Designer Perms
- Sql-server – Issues with maintenance plan – SQL 2016
- Sql-server – How to fix SQL Agent Job using Windows Security after password change
Best Answer
Navigate to SSMS --> Management-->Maintenance plans
Click on you Maint Tasks -->Right Click and select Modify
On this page you find Manage Connections
Check the Manage connections there you find options to change the credentials.