14,494 questions
Probably a bug. Use the Help\Technical Support menu in SSMS to report the issue to the team so they can look at it.
SQL Server Management Studio 18.9 unable to open maintenance plan
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(163.2, 79%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJE%3C/text%3E%3C/svg%3E)
James Edmonds
831
Reputation points
Hi,
We have a SQL server running SQL server 2014.
If I run SSM 18.8 on another server, I can connect remotely and open some maintenance plans.
If I run SSM 18.9.1 on my PC and try to connect remotely and open the same maintenance plans, I get errors as below:
Value cannot be null.
Parameter name: component (System.Design)
------------------------------
Program Location:
at System.ComponentModel.Design.DesignerHost.System.ComponentModel.Design.IDesignerHost.GetDesigner(IComponent component)
at Microsoft.DataTransformationServices.VsIntegration.DtsDesignerService.OpenDesigner(String connectionString, Object connection, String objectUrn)
at Microsoft.SqlServer.Management.DatabaseMaintenance.MaintDesignerMenuHandler.Invoke()
Anyone know why I can't open these with the version of SSMS running on my PC?
Thanks
James
SQL Server | Other
Accepted answer
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 32%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
Michael Taylor 60,161 Reputation points2021-07-15T13:48:05.99+00:00 -
James Edmonds 831 Reputation points
2021-07-16T08:54:43.21+00:00 I have seen this problem reported a lot for older versions of SQL and SSMS when searching the web, but we are talking about 4 or 5 years ago.
Could be a bug given one build of SSMS 18 works and another doesn't, but I wonder if it may be an install problem with SSMS on my laptop specifcally.I'll report it and see if anything comes of it.
Thanks
James -
James Edmonds 831 Reputation points
2021-07-22T12:21:45.703+00:00 You were right, updated to 18.9.2 and I can now open the plans!
Sign in to comment -
1 additional answer
Sort by: Most helpful
-
CathyJi-MSFT 22,396 Reputation points Microsoft External Staff2021-07-16T06:44:13.987+00:00 Hi @James Edmonds ,
From your description, did you mean you could using SSMS 18.8 on server A to access the maintenance plan in SQL 2014 instance on server B. But you could not using SSMS 18.9.1 on server C to access the maintenance plan in SQL 2014 instance on server C? If I misunderstood, please let me know.
I test this in my environment, it works well,
Suggest you manually registering the DTS at a command prompt.
- You need to first locate the C:\Programs Files\ Microsoft SQL Server\120\DTS\Binn directory from Command prompt.
2.Type regsvr32 dts.dll and confirm the DTS.DLL has been registered.
By the way, SSMS 18.9.2 is the latest version of SSMS, you can get it from here.
If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.
-
James Edmonds 831 Reputation points
2021-07-16T08:52:30.897+00:00 Sorry, to try and clarify;
SQL 2014 runs on Server A
SSMS 18.8 on server B can access the maintenance plans on server A remotely and edit them
SSMS 18.9 on server C can connect to server A, but can not edit maintenance plansServer C in my case is my laptop.
I had seen the suggestion to run that dll reg before, however I do not have SQL installed on my laptop, only SSMS, and there do not have that directory from which to register the DLL.Many thanks.
James
Sign in to comment - You need to first locate the C:\Programs Files\ Microsoft SQL Server\120\DTS\Binn directory from Command prompt.