Re: Log of Logins/Logouts

From: Dejan Sarka (dejan_please_reply_to_newsgroups.sarka_at_avtenta.si)
Date: 06/27/03 

Date: Fri, 27 Jun 2003 08:34:47 +0200

Len,

More detailed info can be audited using the Profiler. Check the "Monitoring
with SQL Profiler" part in Books OnLine
(mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books\ad
minsql.chm::/ad_mon_perf_86ib.htm). 

-- 
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Len" <lenny3k@hotmail.com> wrote in message
news:090301c33c01$517e9570$a001280a@phx.gbl...
> 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: dbo qualified name error w Access 2003
    ... correctly, things ended up being owned by dbo, which is *not* ... One tool you should use is SQL Profiler. ... to see the calls between Access and SQL Server, ... >When I use an adp from Access 2000, this code executes successfully for all ...
    (microsoft.public.sqlserver.msde)
  • Re: Locking ASP.NET Session State with SQL Server
    ... SQL Server session state is retrieving and saving varbinary/image ... Go watch it work with SQL Profiler turned on. ... It seems that the sql server solutions is not very scalable or reliable. ... > because all pooled connections were in use and max pool size was> reached. ...
    (microsoft.public.dotnet.framework.performance)
  • RE: Application error event every minute on MSSQLSERVER : "Failure Audit: Login failed for user NT A
    ... Server is 2000, you can open Enterprise Manager, expand your SQL Server ... Also since "NT AUTHORITY\SYSTEM" is a service account, ... you can run SQL Profiler to monitor your SQL Server instance and add ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.security)
  • Re: Application error event every minute on MSSQLSERVER : "Failure Audit: Login failed for user NT A
    ... Server is 2000, you can open Enterprise Manager, expand your SQL Server ... Login..., and then add the Windows login "NT AUTHORITY\SYSTEM". ... you can run SQL Profiler to monitor your SQL Server instance and add ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.security)
  • SQL server is bussy
    ... You can use SQL Profiler to check if the user actually ... tried connecting to your SQL Server through the ... You can check Audit Login/Audit Login failed ...
    (microsoft.public.sqlserver.server)