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 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy