• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 528
  • Last Modified:

Log successful login and logout

How can I configure SQL Server 2000 to log successful login and logout?
0
sepknow
Asked:
sepknow
1 Solution
 
fmonroyCommented:
login and logout from what? database?
0
 
sepknowAuthor Commented:
Yes.
0
 
rivusglobalCommented:
Are you using Windows Auth, SQL Auth, or Mixed Mode?
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
fmonroyCommented:
Logon: http://msdn2.microsoft.com/en-us/library/bb326598.aspx

There is no log out trigger, can you catch it at your application?
0
 
sepknowAuthor Commented:
Mixed Mode.

In SQL 2005, it can be done in the server setting,
but I am using SQL Server 2000.
0
 
itdrmsCommented:
you could turn on the SQL trace for that.
DBCC TRACEON (4013)

From http://searchsqlserver.techtarget.com/generic/0,295582,sid87_gci1110445,00.html
`This trace flag writes an entry to the SQL Server error log when a new connection is established. If you set this option, your error log can fill up quickly. For each connection that occurs, the trace flag writes two entries that look like this:

Login: sa saSQL Query Analyzer(local)ODBCmaster, server
process ID (SPID): 57, kernel process ID (KPID): 57.
Login: sa XANADUsaSQL Query Analyzer(local)ODBCmaster,
server process ID (SPID): 57, kernel process ID (KPID): 57.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now