Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Odd Error Message Expand / Collapse
Author
Message
Posted Thursday, March 8, 2012 3:32 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, August 7, 2014 4:32 AM
Points: 40, Visits: 385
Morning

Just going throught my 2012 SSMS to a 2008r2 server, and I got the following error message, which I've never seen before.

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.

which is a bit odd as I'm the sysadmin on the box. Once I've clicked through I seem to be able to do all I need to do on the box.

I can find nothing online, and when clicking the link for more help, it comes back with no information in the Knowledge base at this time.

Anyone got any ideas?

Ta

pete
Post #1263503
Posted Thursday, September 27, 2012 12:46 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, February 17, 2013 9:33 PM
Points: 1, Visits: 65
I just had the same on SQL Server 2012. In my case the message doesn't seem to be persistent. What is a more persistent is failure of the "Show Policy Health State for all nodes" to take effect. With policies enabled and evaluated, pressing this icon is not working. I have had the policy indicators (icons) light up previously but don't seem able to get them back. Otherwise policy evaluation is working as expected. It would just be nice to get the GUI bit working.
Post #1365053
Posted Tuesday, April 30, 2013 11:48 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, December 7, 2013 9:38 AM
Points: 2, Visits: 25
I am having the exact same message and scenario, did you find a resolution?
Post #1448170
Posted Tuesday, April 30, 2013 3:20 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, August 25, 2014 1:31 PM
Points: 93, Visits: 741
I had the same problem about two months ago, and this article helped me

http://www.sqlservercentral.com/blogs/mssqlfun/2013/01/15/the-server-principal-xxxx-is-not-able-to-access-the-database-msdb-under-the-current-security-context/

Miguel
Post #1448257
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse