Sql Server Logs (no items) showing in Enterprise Manager

  • When I look in Enterprise Manager under Management, SQL Server Logs, it shows (no items).  There is an errorlog, I can read it by running a query, xp_readerrorlog, and it is in startup jobs.  Does anyone have any ideas why the logs do not show in EM?  I have tried to research this on the internet with no results.  I just started monitoring this system so I don't know the history of it.  Any Ideas?

  • Could it be a permissions issue ? Are you using the same credentials for EM that you use in QA to run xp_readerrorlog ?

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • Yes, I am signed on the server when I open EM and when I run the query.  I run the query from EM.

  • Do you have the sysadmin role either given directly to your user or via a group? I have just added this to a test user and this user can now see the SQLServer logs whereas before they were missing from the menu in Enterprise Manager.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply