How to determine when someone logged in?

Question

How to determine when someone logged in?

imani_technology

SSCrazy Eights

Points: 8200
More actions
January 9, 2013 at 3:30 pm

#272652

Please forgive my ignorance. I am more of a BI developer than a DBA. Is there a way to determine when users logged into a specific SQL Server 2008 database within the past month?

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Mac1986 SSCertifiable Points: 6216 More actions · Answer 1

I guess It should be stored in the SQL Server Logs. but not sure what was the retension period your SQL Instance was set to.

SQLisAwe5oMe SSChampion Points: 14052 More actions · Answer 2

imani_technology (1/9/2013)
Please forgive my ignorance. I am more of a BI developer than a DBA. Is there a way to determine when users logged into a specific SQL Server 2008 database within the past month?

I think the best way to track this is to create logon trigger or since this is SQL 2008, you need to enable the CDC under the database level and you can track any DML activities that way.

SueTons.

Regards,
SQLisAwe5oMe.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 3

You can do any of the following:

Logon Trigger

Database/Server Audit

That is if the logon you are seeking is a database logon or a server logon. If the logon is within the app and uses a shared logon, you will need to modify the application to store last logon attempt date and time.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Joie Andrew One Orange Chip Points: 27360 More actions · Answer 4

In management studio right-click on the instance name and go to properties. Click on Security and in the "Login auditing" section select the "Both failed and successful logins" radio button. Click OK.

Joie Andrew
"Since 1982"

Arun-235202 Old Hand Points: 385 More actions · Answer 5

1.Enable the login audit. you choice success or failed.

2.Since your BI expert . Write SSIS package or even TSQL code to read the errorlog and filter only audit records and insert data into table.( you can play around with the data :-))

Then enjoy with required data.

Grant Fritchey SSC Guru Points: 398886 More actions · Answer 6

You can also create extended events to capture all logins.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning