dbTalk Databases Forums  

MSAS activity loggin

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss MSAS activity loggin in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Jeroen
 
Posts: n/a

Default MSAS activity loggin - 05-20-2005 , 01:17 PM






I have started SQL Profiler to log the 'login audit' and 'logout audit' for
our SQL server database.

I would like to do the same for MSAS where I can see the NT Username etc.
Does anybody know how to do this? I had a look at the server properties and I
have enabled logging but the help nor a file sais something about what have
been logged...

Reply With Quote
  #2  
Old   
Dave Wickert [MSFT]
 
Posts: n/a

Default Re: MSAS activity loggin - 05-20-2005 , 04:23 PM






If AS2K5, then we have added SQL Profiler support
If AS2K, then you need to update some registry values.
See this white paper:
http://msdn.microsoft.com/library/de...egsettings.asp
And look at the AuditEvents key

Hope that helps.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"Jeroen" <Jeroen (AT) discussions (DOT) microsoft.com> wrote

Quote:
I have started SQL Profiler to log the 'login audit' and 'logout audit' for
our SQL server database.

I would like to do the same for MSAS where I can see the NT Username etc.
Does anybody know how to do this? I had a look at the server properties
and I
have enabled logging but the help nor a file sais something about what
have
been logged...



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.