August 27, 2007 at 12:41 pm
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?
August 28, 2007 at 8:42 am
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."
August 28, 2007 at 10:25 am
Yes, I am signed on the server when I open EM and when I run the query. I run the query from EM.
January 19, 2011 at 6:02 am
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