We have a SqlServer database that we run using Windows Authorization. I want to set up a server login for a particular user who is remoting in. In the management tool, I enter the user name, password, and confirm the password. Then save. The user is unable to log in.
When I re-open the login, the password appears to have been changed. It's a different number of characters. Since they are obscured, I can not see what they are.
It's not a problem with the management tool. Same result with two different SQL Managers.
What's going on?