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.