Question: how to create user for database in sql server?
Answer: In the Object Explorer of SQL Server Management Studio, navigate to the Security folder and expand it.
Right-click the Logins folder and choose New Login. ... 
Select the General page, and then enter a user name in the Login name text box.