SQL Server Authentication: At first go to security > logins > New Login
Now, add name (msa), password (123456) and rest will be unchanged.
Here we see that how we create a user, now we will permission this into various database.
For setting permission we first right click on user what we create before then go to propertites
Then select User Mapping
