none
SQL Server Usage Summary page, the count of user/device: does not show for SQL Server 2008 RRS feed

  • Question

  • Does MAP tool capture User Summary  (count of users, their details) for SQL Server 2008? 

    At my end, its working for SQL Server 2012 but not showing User Summary for SQL Server 2008..

    Does the User Summary only works for SQL Server 2008 Enterprise edition as one of the thread points out?

    Tuesday, August 19, 2014 2:45 PM

All replies

  • This is from the Wiki article:

    SQL Server 2008 Enterprise and Datacenter Editions introduced audit event configuration for Windows security logging, which enabled SQL Server 2008 to log logon events to the Windows Security log. The table below shows which versions and editions have the Audit feature that is needed to record the logon events. MAP cannot obtain user and device access information for any other editions or any older versions of SQL Server.

      Datacenter Enterprise Business Intelligence Standard Workgroup Web Express
    SQL Server 2008

    N/A

    Yes

    N/A

    No

    No

    No

    No

    SQL Server 2008 R2

    Yes

    Yes

    N/A

    No

    No

    No

    No

    SQL Server 2012

    N/A

    Yes

    Yes

    Yes

    N/A

    Yes

    Yes



    Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. Please VOTE as HELPFUL if the post helps you. This can be beneficial to other community members reading the thread.

    Wednesday, October 15, 2014 7:36 PM
    Moderator