Permission to access the msdb database is required for this feature to work correctly

Question

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.

---

Agha Khan

Answer 1

Hi there,

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

dbcc checkdb('msdb')

if you have errors restore it from a back up or repair it.

thanks

kumar