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.