Report on successful sql logins

Looking for how to create a report for sql'05 to see who's logging in succes
fully and then failed user logins as well perhaps on a second report.
Is there a way to capture logins historically with just sql server? How do
you set this up? Could someone point me in the right direction or, possibly
an example?
ThanksGo to Server Properties, Security tab, Login auditing. Login information
will be written to SQL Server Log and Windows Event Viewer.
Ben Nevarez, MCDBA, OCP
Database Administrator
"James Wuerflein" wrote:

> Looking for how to create a report for sql'05 to see who's logging in succ
esfully and then failed user logins as well perhaps on a second report.
> Is there a way to capture logins historically with just sql server? How d
o you set this up? Could someone point me in the right direction or, possib
ly an example?
> Thanks
>|||What an easy way to take that an create a report forthose logins that I coul
d give to management?
Thanks

Go to Server Properties, Security tab, Login auditing. Login information
will be written to SQL Server Log and Windows Event Viewer.
Ben Nevarez, MCDBA, OCP
Database Administrator
"James Wuerflein" wrote:
[vbcol=seagreen]
> Looking for how to create a report for sql'05 to see who's logging in succ
esfully and then failed user logins as well perhaps on a second report.
>
> Is there a way to capture logins historically with just sql server? How d
o you set this up? Could someone point me in the right direction or, possib
ly an example?
>
> Thanks
>

Report Model Filtering

When creating a filter with Report Model against my cube (or perhaps any
source) - it seems to force me to free form type how the filter will work.
For example -
Attribute: Does_Client_Smoke
Values: Yes, No, N/A, Won't Answer, Cannot Answer
When I create the filter it makes me type in one of the above values instead
of letting me select it from a pull-down such as how BIDS works - what am I
doing wrong here?Can someone help me on this question below. When using the report viewer,
there is a BACK button but when using browser, it won't page back correctly.
I'm using latest IE beta - maybe that's my issue?
"Joe" <hortoristic@.gmail dot com> wrote in message
news:%23ZxRAzSzGHA.772@.TK2MSFTNGP05.phx.gbl...
> When creating a filter with Report Model against my cube (or perhaps any
> source) - it seems to force me to free form type how the filter will work.
> For example -
> Attribute: Does_Client_Smoke
> Values: Yes, No, N/A, Won't Answer, Cannot Answer
> When I create the filter it makes me type in one of the above values
> instead of letting me select it from a pull-down such as how BIDS works -
> what am I doing wrong here?
>