I am new to SQL Server and am trying to create a new login ID and password with permissions. I am successful at creating the new login, but my problem is with the password. At the point where I am creating the login account, I specify a password, but after I create the account, the system seem to create it's own random password for me.
This is not the desired result. How do I deal with this problem?