Can't edit maintenance plans after upgrade to SQL Server 2016


We recently upgraded our test Environments from SQL Server 2012 to SQL Server 2016 (SP1). After the upgrade we get en error whenever we try editing Maintenance Plans. I can open Maintenance Plans from Management Studio (13.0.16106.4) but non of the tasks are editable. Renaming a maintenance plan from the GUI gives me the error "Login failed for user 'sa' (Microsoft.SqlServer.IntegrationServices.ObjectExplorerExtensions)". Deleting a plan and recreating it works, and renaming a plan I created after the upgrade works fine. Also, in the GUI, when I open a task, I can change properties in the properties window, but I can't edit the task from the popup window. The OK button is disabled.

Did anyone else experience the same thing (and yes I know, Maintenance plans are..... But now we have them...)

more ▼

asked Jun 21, 2017 at 10:55 AM in Default

avatar image

Magnus Ahlkvist
22.3k 20 43 43

This might be a dumb question but who are you logged in as?

Jul 07, 2017 at 12:04 PM Waqar_lionheart
(comments are locked)
10|1200 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Jun 21, 2017 at 10:55 AM

Seen: 84 times

Last Updated: Jul 07, 2017 at 12:04 PM

Copyright 2018 Redgate Software. Privacy Policy