Solved

tracking logins into SQL Server

Posted on 2010-08-26
6
387 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
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure 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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

679 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