Solved

tracking logins into SQL Server

Posted on 2010-08-26
6
388 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

Question has a verified solution.

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

Suggested Solutions

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

752 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