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 on successful sql logins

--____SBTWNWYYMXLIXECXQHOY____
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
Looking for how to create a report for sql'05 to see who's logging in = succesfully 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?
Thanks
--____SBTWNWYYMXLIXECXQHOY____
Content-Type: multipart/related; boundary="____NDKLCVQYBPHYCAFJJABM____"
--____NDKLCVQYBPHYCAFJJABM____
Content-Type: text/html; charset=windows-1252
Content-Transfer-Encoding: quoted-printable
&
Looking for how to create a report for sql'05 to see who's logging in = succesfully and then failed user logins as well perhaps on a second = report.

Is there a way to capture logins historically with just sql server?&nb= sp; How do you set this up? Could someone point me in the right = direction or, possibly an example?

Thanks
--____NDKLCVQYBPHYCAFJJABM____--
--____SBTWNWYYMXLIXECXQHOY____--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:
> Looking for how to create a report for sql'05 to see who's logging in succesfully 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?
> Thanks
>|||--____OGQMDAXZFWTVEKBBRRSF____
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
What an easy way to take that an create a report forthose logins that I =could give to management?
Thanks
>> Ben Nevarez<BenNevarez@.discussions.microsoft.com> 05/03 6:37 PM >>
Go to Server Properties, Security tab, Login auditing. Login information=20=
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 =succesfully 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?
> > Thanks
>
--____OGQMDAXZFWTVEKBBRRSF____
Content-Type: multipart/related; boundary="____CECFBOUWBBNUBTTKVERM____"
--____CECFBOUWBBNUBTTKVERM____
Content-Type: text/html; charset=windows-1252
Content-Transfer-Encoding: quoted-printable
&

---

What an easy way to take that an create a report forthose logins that =I could give to management?
Thanks> Ben Nevarez 05/03 6:37 PM >>
Go to Server Properties, Security tab, =Login auditing. Login information will be written to SQL Server Log =and Windows Event Viewer.Ben Nevarez, MCDBA, OCPDatabase =Administrator"James Wuerflein" wrote:> Looking for =how to create a report for sql'05 to see who's logging in succesfully 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?> > Thanks> =

---

--____CECFBOUWBBNUBTTKVERM____--
--____OGQMDAXZFWTVEKBBRRSF____--