In which form Microsoft SQL password should be given when creating a user?

Question

I am creating a Microsoft SQL server user with the guidance of this MSDN article and giving the system the following commands:

CREATE LOGIN MyName WITH PASSWORD = 'MyPass';
USE My$DatabaseName;
CREATE USER MyName FOR LOGIN MyName;
GO

I use SQL Studio to look again the password by clicking the name on Logins list. There I see too many stars on the password that it could represent my given password.

My question is that if I gave the password according to that I wrote (in plain text), did I give it correctly? I have problems to login to the database and I don't know now is the password there ok or not.

(The link on MSDN does not say anything about encrypting, but I cannot say if the example passwords follow some encrypting rule or not.)

Answer 1

Yes, it is there correctly. You have run CREATE LOGIN correctly.

The number of stars in the SSMS box is just a mask and is unrelated to your actual password. SSMS doesn't know or try to read your password from the server

Note that SQL Server doesn't store your password so it can't relate to the **** in SSMS anyway. SQL Server hashes it into the password_hash column of sys.server_principals