在哪里记录SQL Server连接尝试？ [英] Where are SQL Server connection attempts logged?

问题描述

SQL Server是否有用于尝试连接的外部日志文件或内部表，或者是那种信息放在Windows事件日志中的某处？

解决方案

您可以启用连接记录。对于SQL Server 2008，您可以启用登录审计。在SQL Server Management Studio中，打开SQL Server属性>安全性>登录审核选择失败和成功登录。

确保重新启动SQL Server服务。 p>

一旦你这样做，连接尝试应该被记录到SQL的错误日志。可以此处确定物理日志位置。

Does SQL Server has an external log file or internal table for attempted connections, or is that kind of info put somewhere in the Windows Event Log?

解决方案

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.

这篇关于在哪里记录SQL Server连接尝试？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！