Create Login SQL Server
Create Login
Choose your database and run the following code. Choose your own Login and User.
Ex:
Test Login
Open a new SQL Server Instance and test your new Login and Password.
Add Database Role to Login
Go back and add the appropriate Database Role to your User.
SQL Tutorial