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.