I don't think you need to update the owner password in maintenance plan after changing it in SQL Server. It will automatically take it from the SQL Server. If you...

Thanks for the nice suggestion ,its really good. But here i was doing it by the maintenance plan name so didn't want to use package type.

Thanks.

Thanks for the new addition. These are really helpful.

You are welcome 🙂

Hi Steve,

You can change the SQL server virtual name and not the instance name.

Hi Steve,

Please have a look at below article.

http://msdn.microsoft.com/en-us/library/ms178083.aspx

We can change the SQL Server virtual name but not the instance name.

Hi Steve,

As far as I think, change of named instance is not possible. You need to uninstall and install again.

Nice connection OldFashionGang.

Thanks for the advice. Learnt a new scenario and issue today.

Hi,

Nothing happens to existing databases. All databases and configuration will not be affected.

Shashank

Thanks for the suggestion.

Thank you for the modification . Yes we need to make those changes to include databases that have spaces.

Happy to help you. Thanks

Thanks.