Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

tracking logins into SQL Server

Posted on 2010-08-26
6
Medium Priority
?
392 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 2000 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
Independent Software Vendors: 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 2000 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

Fill in the form and get your FREE NFR key NOW!

Veeam® is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Question has a verified solution.

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

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…
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

722 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