Question: how to create user for specific database in sql server?
Answer: Open SQL Server Management Studio (SSMS).
Connect to SQL Server using your log in information.
In the left-hand panel, expand Security > Logins.
Right click Logins and select New Login from the drop-down menu.
Assign a Login name and select the authentication method and default database/language.