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

问题描述

SQL Server 是否有用于尝试连接的外部日志文件或内部表，或者此类信息是否放在 Windows 事件日志中?

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?

推荐答案

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

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".

确保重新启动 SQL Server 服务.

Make sure to restart the SQL Server service.

完成此操作后，连接尝试应登录到 SQL 的 错误日志.可以在此处确定物理日志位置.

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屋！