Who last logon/logoff to the SQL Server?

[GeeWond3r]

Where would I find who last logged on/off from the SQL Server during a paricular period (let's say from 2pm to 5pm yesterday).

Out of the blues, my web pages was unable to access the database. So I'm trying to troubleshoot where the problem is. I had to restart the db server for it to work again.

Any ideas/suggestions would be helpful..

 

[SQLBill]

In Enterprise Manager, expand down to Management, expand that, expand SQL Server Log, look in the latest log. If Auditing is set for the instance then the log will have who logged on and off.

-SQLBill