Sql-server – Sql Server user password changes by itself

passwordresetsql serverusers

This the same question as this:

Sql server automatically change password

However, the user never specified how he fixed it, he only said that he fixed it. I am having the exact same issue. Whenever I try to create a new user login and password, the password immediately changes to an unknown, 15-character password.

@Aram Gevorgyan was the original poster of the question

EDIT:
I create a new login like this and click ok

Then if I check the properties for the login immediately after, it looks like this

I am using windows 10 and just installed the newest version of sql server express and sql server management studio

Best Answer

I'd be able to be more precise if you'd edit your question with as many details as you can.

With the provided details that's what I can answer; too long for comments.

This really looks like some kind of security related issue. Have you turned on logging? What does logs look like? Have you tried having the network cable unplugged for a while until the password "automagically" changes? This may lead to identify the threat as a local or a network one. You didn't provide any detail at all in your question regarding your system nor your environment nor your applications working on dbs. Without any of those it's impossible to get rid of your issue and I can guarantee you that you'll get quickly downvoted even if the question itself is an interesting one. I'd try to scan this server for virus/malware/scripts/unknown services then I would come back here editing the question with as many details as possible.

To confirm that I'm right, just bring up a Ms Windows Server VM, install Sql in evaluation mode, restore your dbs, create your users, set passwords and I ensure you passwords won't "automagically" change.

Related Topic