Solved

tracking logins into SQL Server

Posted on 2010-08-26
6
383 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
VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

 
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

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Server Deadlocks 12 50
Permissions on Database 11 37
SQL Server - Slabs 9 38
Sum Totals based on current date compared to fiscal year to get YTD totals 3 19
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
I have a large data set and a SSIS package. How can I load this file in multi threading?
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

895 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