• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 523
  • 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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
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

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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