To create a SQL Server login that uses choose Windows Authentication (SQL Server Management Studio)
In SQL Server Management Studio, open Object Explorer and expand the folder of the server instance in which to create the new login.
Right-click the Security folder, point to New, and then click Login.
On the General page, enter the name of a Windows user in the Login name box.
Select Windows Authentication.
Click OK
or query
create login <login name> with password='<passwordname>'