Sql-server – SSMS Cannot show the editor for this task (Notify Operator Task)

database-mailsql serversql-server-2016ssms

I'm getting an error message whenever I double click on a Notify Operator Task in our Maintenance Plans in SSMS, which says "Cannot show the editor for this task."

Property IsMailHost is not available for Database '[msdb]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Smo)

Database mail is configured and working OK.

I'm using SQL Server 2016 (13.0.4411.0) and SSMS 13.0.16106.4.

Interrogating the IsMailHost property via PowerShell seems to indicate that the IsMailHost property is true.

$db = SqlServer\Get-SqlDatabase -ServerInstance sqlserver1 -Name msdb
Write-Host $db.IsMailHost

The above script returns True.

If I try to open a Notify Operator Task on our old SQL 2008 server, with SSMS 10.0.5538.0, it works fine, but with SSMS 13.0.44110.0, I get the same error message. I'm beginning to think it's a fault with this build of SSMS rather than a configuration issue with the server.

Best Answer

According to this SSMS on Microsoft Docs

Build number 14.0.17099.0 will likely fix your issue.

Fixed an issue where "Maintenance Plans Tasks Toolbox" items may be missing in SSMS.