Log all connections to a SQL Server

I need to log all users connecting to any database on my SQL Server 2000
cluster.

Anyone know how I can accomplish this ?

Ta,

CJ.Hi

Some options:

On the security tab for the server you can set login auditing.
You can also set C2 auditing on for more information.
You can use profiler to log these events.
You can use a third party tool.

John
"Chris Sleightholme" <sleightholme@.ntlworld.com> wrote in message
news:r7Byd.945$Rz6.861@.newsfe2-win.ntli.net...
>I need to log all users connecting to any database on my SQL Server 2000
> cluster.
> Anyone know how I can accomplish this ?
> Ta,
> CJ.|||Try this in Query Analyzer,
use master
go
Select * from sysprocesses

This should give you all the fields you need.

Oscar...

"Chris Sleightholme" <sleightholme@.ntlworld.com> wrote in message
news:r7Byd.945$Rz6.861@.newsfe2-win.ntli.net...
> I need to log all users connecting to any database on my SQL Server 2000
> cluster.
> Anyone know how I can accomplish this ?
> Ta,
> CJ.