Problem with "SA" password | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Problem with "SA" password

I have typical problem going with Sql server 2000. "SA" password changes automatically for every two or three weeks . I am not sure what exactly going on ..but for temporary solution …I used to fix it with "sp_adduser" function. What is the reason for this and any permanent fix to resolve this issue?
Thanks in advance
VENU
Hi Venu,
AFAIK i don’t think its possible , check if any other Administrator do it. generally if password policy is set in Domain it force user to change the password upon expiry of the password after given period but it won’t change automatically. is their any other SQL Administrator / Administrator in your organisation who change password ! unless i don’t think it changes automatically.
Regards Hemantgiri S. Goswami
[email protected]
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami

True and it is not a good practice about not able to keep at track of SA passowrd.
Until unless the user initiates the SA password will not be changed or attempted by SQL itself.
BTW what kind of other applications you’re using apart from SQL server? Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Bit Strage, You mean SA passoword is changing automatically. —————————————-
http://dineshasanka.blogspot.com/

You need to delineate the responsilities and accountabilities of people using SA (or your boss). If you’re sharing that role with other sysadmins/DBAs, you should enforce change log mechanism or quality controls to ensure that only authorized personnel can view and communicate through that document. If you have nailed down the communication/politics issue, then, we can start monitoring (or audit) your servers and find out who’s doing what <img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />.<br /><br />May the Almighty God bless us all!<br />www.empoweredinformation.com
Try leaving the profiler running to record when it happens.

.. I hope this is a development environment.. if not then try to fix the security hole… that may cost your job. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided �AS IS� with no rights for the sake of knowledge sharing.
]]>