logging - Where are SQL Server connection attempts logged? -


does sql server has external log file or internal table attempted connections, or kind of info put somewhere in windows event log?

you can enable connection logging. sql server 2008, can enable login auditing. in sql server management studio, open sql server properties > security > login auditing select "both failed , successful logins".

make sure restart sql server service.

once you've done that, connection attempts should logged sql's error log. physical logs location can determined here.


Comments

Popular posts from this blog

linux - Using a Cron Job to check if my mod_wsgi / apache server is running and restart -

actionscript 3 - TweenLite does not work with object -

jQuery Ajax Render Fragments OR Whole Page -