In order to create a login user in sql server follow the following steps:-
step-1: Open MS-SQL Server and click Security and then click Logins.
Step-2: Now right click on the Logins and click "New Login..."
Step-3: You will see a window below as :
Step-4: Now give the name for the login user & choose SQL Server Authentication and this will make the password fields enable, give the password and confirm password uncheck the Enforce password policy and click OK that all..
Enjoy it..........
