SQl服务器用户密码 [英] SQl Server User Password

问题描述

我通过IP地址与sql server连接，但突然sql server更改了sa用户的密码而没有每2~3天更改一次，这是什么原因？

请帮忙？

i connect with sql server through IP address, but suddenly the sql server change the password of "sa" user without i changed it every 2~3 days, what is the reason for that ?
please help ?

推荐答案

SQL Server不会也不会更改自己的SA密码。必须有一些脚本在某个地方运行。您不需要物理访问服务器来更改SA密码。它可以远程完成。

SQL Server does not and will not change the SA password on it's own. There has to be some script running somewhere that is doing it. You do NOT need physical access to the server to change the SA password. It can be done remotely.

检查您的服务器是否感染了病毒

http://www.symantec.com/security_response/writeup.jsp?docid=2002-052108-5430-99 [ ^ ]



http://www.sans.org/security-resources/ idfaq / spider.php [ ^ ]







从sp_password看一下sproc - 有人可能已经入侵它并记录您所做的任何密码更改（允许他们知道sa密码，以便将来可以再次更改）

sproc上的日期应该与大多数密码相同其他系统在master中创建了sprocs（取决于你的版本）。

Check if your server is infected with virus
http://www.symantec.com/security_response/writeup.jsp?docid=2002-052108-5430-99[^]

http://www.sans.org/security-resources/idfaq/spider.php[^]

OR

take a look at the sproc from sp_password -- someone may have compromised it and is logging any password changes you make (allowing them to know the sa password so they can change it again in the future)
The date on the sproc should be the same as the majority of the other system created sprocs in master (depends on your version).

这篇关于SQl服务器用户密码的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！