Re: SQL logins logged where

From: BP Margolin (bpmargo@attglobal.net)
Date: 12/31/02 

From: "BP Margolin" <bpmargo@attglobal.net>
Date: Tue, 31 Dec 2002 13:59:33 -0500

Brian,

SQL Server does not automatically keep a log of who logged in. It really has
no reason to do that. If the user has authorization to use SQL Server, then
SQL Server will allow the user access to SQL Server.

However you can request SQL Server to maintain a log:

Option 1: In SQL Server 2000 Enterprise Manager, right click the server
name, choose Properties, and go to the Security tab. Choose the Audit level
you want, and click the Help button for additional information.

Option 2: You can use SQL Server 2000 Profiler to track logins ... look at
the event under the Security Audit class. Additional information about using
SQL Server 2000 Profiler can be found in the SQL Server 2000 Books Online.

-------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.

"bhayes" <brian.hayes@bankfirstcorp.com> wrote in message
news:053f01c2b0fd$0befe200$89f82ecf@TK2MSFTNGXA01...
> Where does SQL log the database logins at? Kind of like
> the security logs on a server. How can I tell who has
> logged into a SQL server and can we tell where they are
> logging into from?
>

Quantcast