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

Sql Server Logs (no items) showing in Enterprise Manager Expand / Collapse
Author
Message
Posted Monday, August 27, 2007 12:41 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, October 23, 2012 8:48 AM
Points: 71, Visits: 114
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?


Post #394105
Posted Tuesday, August 28, 2007 8:42 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 11:18 AM
Points: 3,193, Visits: 2,289
Could it be a permissions issue ? Are you using the same credentials for EM that you use in QA to run xp_readerrorlog ?



Regards
Rudy Komacsar
Senior Database Administrator

"Ave Caesar! - Morituri te salutamus."
Post #394330
Posted Tuesday, August 28, 2007 10:25 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, October 23, 2012 8:48 AM
Points: 71, Visits: 114
Yes, I am signed on the server when I open EM and when I run the query.  I run the query from EM.


Post #394380
Posted Wednesday, January 19, 2011 6:02 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, January 8, 2014 4:07 AM
Points: 16, Visits: 110
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.
Post #1049985
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse