I am using SQL Server 2012. It was running ok for a while, but today I prompt with
Cannot display policy health state at the server level, because the user doesn’t have permission. Permission to access the msdb database is required for this feature to work correctly.
I looked all over internet but unable to resolve the issue.
Any help will be very much appreciated.
If it was working earlier and not working now with out changing any thing. I suspect your msdb may be corrupted.
run this command. open a new query window
if you have errors restore it from a back up or repair it.
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?