x

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

Hi,

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 at 10:55 AM in Default

avatar image

Magnus Ahlkvist
22k 20 41 42

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

Jul 07 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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x89
x52
x19
x13

asked: Jun 21 at 10:55 AM

Seen: 55 times

Last Updated: Jul 07 at 12:04 PM

Copyright 2017 Redgate Software. Privacy Policy