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 manager

Hello,
I'v tried several times to install RS on a local machine. The install seems
to be succesfully, but i can't see/find the report manager. Everything else
is vissible.
Anyone?Hi Willem,
What are you calling Report Manager ? Is this http://localhost/reports ?
Have you looked at the Log Files ?
Axel Guerrier
Microsoft France
--
Merci de bien vouloir répondre à ce message dans le newsgroup où il a été
posté. Je le consulte régulièrement.
"Willem01" <Willem01@.discussions.microsoft.com> wrote in message
news:29B047CA-85F1-48C5-B77C-B57516673B3A@.microsoft.com...
> Hello,
> I'v tried several times to install RS on a local machine. The install
> seems
> to be succesfully, but i can't see/find the report manager. Everything
> else
> is vissible.
> Anyone?|||Hi Axel,
Yes, That's what i mean. I have IIS installed.
Willem
"Axel Guerrier [MS]" wrote:
> Hi Willem,
> What are you calling Report Manager ? Is this http://localhost/reports ?
> Have you looked at the Log Files ?
>
> --
> Axel Guerrier
> Microsoft France
> --
> Merci de bien vouloir répondre à ce message dans le newsgroup où il a été
> posté. Je le consulte régulièrement.
> "Willem01" <Willem01@.discussions.microsoft.com> wrote in message
> news:29B047CA-85F1-48C5-B77C-B57516673B3A@.microsoft.com...
> > Hello,
> >
> > I'v tried several times to install RS on a local machine. The install
> > seems
> > to be succesfully, but i can't see/find the report manager. Everything
> > else
> > is vissible.
> > Anyone?
>
>|||Problem is solved. Sp1 was not installed. Thanks