sql server new users: How to Track Logins -- sql server new users

You're in the

sql server new users

group:

How to Track Logins

Mike Thomas
2/20/2005 10:00:06 AM

sql server new users: In SQL Server 2000, Developer Edition, is there a way to track logins, both
successful and unsuccessful, after the fact. Eg, is there a way, for
example, to view all login attempts for a previous date?

Many thanks
Mike Thomas

Re: How to Track Logins

Mike Thomas
2/20/2005 6:48:48 PM

Many thanks, Mike

That part is done. What next? Is there a sored procedure I can run which
will show who tried to log in and when?

Thanks
Mike Thomas

[quoted text, click to view]

Re: How to Track Logins

Mike Epprecht (SQL MVP)
2/20/2005 9:57:30 PM

Hi

In Enterprise Manager, Server, Properties, Security Tab. Set audit level to
"All".

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

[quoted text, click to view]

Re: How to Track Logins

Sue Hoegemeier
2/21/2005 7:52:05 AM

The audit entries from the logins will be in the SQL Server
error log. It will show who and when.
You also need to restart the service after changing the
audit login settings.

-Sue

On Sun, 20 Feb 2005 18:48:48 -0500, "Mike Thomas"
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server new users group.

home · blog · groups

Questions? Comments? Contact the dn