Solved

tracking logins into SQL Server

Posted on 2010-08-26
6
384 Views
Last Modified: 2012-05-10
is there any mechanics to track the above, or will we have to do it purely through Event viewer in the OS?

Thanks
0
Comment
Question by:anushahanna
  • 3
  • 3
6 Comments
 
LVL 16

Accepted Solution

by:
vdr1620 earned 500 total points
ID: 33535727
there is an option in the SQL server Settings to Audit your logins..If that is what you are looking for

Go to SSMS and right click your server, choose Properties and then select the Security tab. Select the setting that you want, "Both failed and Successful Logins"
0
 
LVL 6

Author Comment

by:anushahanna
ID: 33535749
OK. So this will get logged in SQL Error log?
0
 
LVL 16

Expert Comment

by:vdr1620
ID: 33535889
No, it gets logged in the SQL Server Event Log
0
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 
LVL 6

Author Comment

by:anushahanna
ID: 33538470
you mean xp_readerrorlog?
0
 
LVL 16

Assisted Solution

by:vdr1620
vdr1620 earned 500 total points
ID: 33538587
No..I am talking about Sql server logs. Under Management ---> SqL server logs..i am not sure about the SP,but definitely not xp_readerrorlog.. It might be sys.Xp_logevent..

I also find a nice article on Sql Login Audits..thought you might be insterested

http://www.sqlservercentral.com/articles/Security/sqlserverauditingpart1/1451/
0
 
LVL 6

Author Comment

by:anushahanna
ID: 33541728
Thanks vdr1620.

actually, it is indeed xp_readerrorlog. the article also references it.
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
I have a large data set and a SSIS package. How can I load this file in multi threading?
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

816 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now