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';
CREATE USER MyName FOR LOGIN MyName;
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.)