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____--