sql-server – SQL Server:如何检查更改SA密码是否安全?

前端之家收集整理的这篇文章主要介绍了sql-server – SQL Server:如何检查更改SA密码是否安全?前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。
如果我更改了Microsoft sql Server的SA密码,我是否可以在日志或跟踪中看到某个应用程序是否尝试使用旧密码登录

解决方法

请参阅此文章/教程,其中介绍了如何在sql Server 2000和2005中启用登录审核:

Who is logging in as the sa login in SQL Server?

The native audit level configuration
is a simple configuration that can
help to determine if the sa login is
used in the sql Server instance. What
this configuration does is records all
of the successful (or @R_301_159@ or both)
logins into a particular sql Server
instance. You will not know the host
name,application,etc. However,this
configuration will enable you to
determine if the sa login is being
used in the first place. Once you
have this information,then you can
dig deeper with sql Server Profiler
outlined below.

对于sql Server 2008,有一个new feature “SQL Server Audit”.以下文章解释了如何autid登录,包括示例脚本:SQL Server Audit in SQL Server 2008.

原文链接:https://www.f2er.com/mssql/80727.html

猜你在找的MsSQL相关文章