Where are SQL Server connection attempts logged?

by

You can enable connection logging. For SQL Server 2008, you can enable Login Auditing. In SQL Server Management Studio, open SQL Server Properties > Security > Login Auditing select “Both failed and successful logins”.

Make sure to restart the SQL Server service.

Once you’ve done that, connection attempts should be logged into SQL’s error log. The physical logs location can be determined here.

More Related Contents:

  1. How to connect to local instance of SQL Server 2008 Express
  2. Export query result to .csv file in SQL Server 2008
  3. Enable ‘xp_cmdshell’ SQL Server
  4. A connection was successfully established with the server, but then an error occurred during the pre-login handshake
  5. Sql Server ‘Saving changes is not permitted’ error ► Prevent saving changes that require table re-creation
  6. SQL MERGE statement to update data
  7. How to get the last record per group in SQL
  8. A transport-level error has occurred when receiving results from the server [closed]
  9. A network-related or instance-specific error occurred while establishing a connection to SQL Server [closed]
  10. How can I load a large flat file into a database table using SSIS?
  11. storing passwords in SQL Server
  12. How does sql server sort your data?
  13. How to restore to a different database in SQL Server?
  14. Reporting Services permissions on SQL Server R2 SSRS
  15. T-SQL substring – separating first and last name
  16. SQL Server: Split operation
  17. How to implement polymorphic associations in an existing database
  18. How to get week number of the month from the date in sql server 2008
  19. Optional parameters in SQL Server stored procedure
  20. Entity Framework Database.SetInitializer simply not working
  21. Cannot open backup device. Operating System error 5
  22. Restoring database from .mdf and .ldf files of SQL Server 2008
  23. Restrict SQL Server Login access to only one database
  24. T-SQL strip all non-alpha and non-numeric characters
  25. How can I get a trigger to fire on each inserted row during an INSERT INTO Table (etc) SELECT * FROM Table2?
  26. Can I pass variable to select statement as column name in SQL Server [duplicate]
  27. SQL Server 2008 Connection Error “No process is on the other end of the pipe”
  28. SSIS LookUp is not dealing with NULLs like the docs say it should
  29. Recursive Child/Parent queries in T/SQL
  30. Forcing code-first to always initialize a non-existent database?

Leave a Comment