question

JamesEdmonds-7766 avatar image
0 Votes"
JamesEdmonds-7766 asked JamesEdmonds-7766 commented

SQL Server Management Studio 18.9 unable to open maintenance plan

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-general
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

cooldadtx avatar image
1 Vote"
cooldadtx answered JamesEdmonds-7766 commented

Probably a bug. Use the Help\Technical Support menu in SSMS to report the issue to the team so they can look at it.

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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

0 Votes 0 ·

You were right, updated to 18.9.2 and I can now open the plans!

0 Votes 0 ·
Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered JamesEdmonds-7766 edited

Hi @JamesEdmonds-7766,

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.

  1. 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.



· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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 plans

Server 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

0 Votes 0 ·