Log of Logins/Logouts

From: Len (lenny3k_at_hotmail.com)
Date: 06/26/03 

Date: Thu, 26 Jun 2003 09:38:05 -0700

Hi there.

I am looking for a way to log details of all
logins/logouts for an SQL 2000 Server. So far, I've come
across using the 'Security' tab in the
database 'properties' dialog (Enterprise Mgr - right-click
on the database..) to enable "Audit ALL".

This allows me to view logins & logouts in the Server logs
(under the 'Management' tree). Unfortunately, I can't get
enough information from this:

-The log records only show a user name for the events - I
don't know how to find out how the IPAddress or any more
information on the login.

Any ideas where I might find such info?

Basically, user name isn't enough to identify applications
for me because the applications I'm looking for all use
the same one.

Any help would be appreciated!

(I'm new at this btw!...)

Len.

Relevant Pages

  • RE: Creating a DB User *not* on current Machine
    ... detach/attach the database to a new server. ... Server.When you move a database from one server that is running SQL Server ... the security identification numbers of the logins in the master ...
    (microsoft.public.sqlserver.security)
  • Re: Logins
    ... no databases are checked, ... On the Server Roles tab, ... That server was upgraded to SQL Server ... moved, I recreated the SQL Server logins we had added, making sure that the ...
    (microsoft.public.sqlserver.security)
  • Re: transfering logins
    ... has their name, password, and a SID, among other attributes. ... In <your database>.dbo.sysusers, you will notice that each database user has ... database not a server object), but since the SIDs are generated at random, ... do not have this problem with Windows logins (hint: ...
    (microsoft.public.sqlserver.security)
  • Re: transfering logins
    ... has their name, password, and a SID, among other attributes. ... In <your database>.dbo.sysusers, you will notice that each database user has ... database not a server object), but since the SIDs are generated at random, ... do not have this problem with Windows logins (hint: ...
    (microsoft.public.sqlserver.security)
  • Creating/Altering Database Schemas via Code
    ... to create/alter the database for a suite of ... the server in an INI file) ... I have never heard of major applications (a suite of at least 9 client ...
    (microsoft.public.vstudio.general)