Enable logging of Successful logins

If you want to see successful logins in SQL Powerhouse, then you must enable logging of successful logins on your SQL server.

You can follow successful logins over a period of time (12 month), by IP address and / or Username.

To enable it, open SQL server Management studio.

  1. Right click the instance and choose properites. the Properties window will open.
  2. Go to the security Tab, and click "both Failed and Successful logins only".
  3. Click OK.

Now both successful and failed logins are logged and it can be monitored in SQL Powerhouse.




Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request


Please sign in to leave a comment.