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

发布时间：2020-12-12 17:00:13 所属栏目：MsSql教程来源：网络整理

导读：如果我更改了Microsoft SQL Server的SA密码,我是否可以在日志或跟踪中看到某个应用程序是否尝试使用旧密码登录？解决方法请参阅此文章/教程,其中介绍了如何在SQL Server 2000和2005中启用登录审核： Who is logging in as the sa login in SQL Server? The

如果我更改了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 failed 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.

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!