Create User and Login in sql server database

CREATE LOGIN loginname
    WITH PASSWORD = 'yourpassword';
GO

-- Creates a database user for the login created above.
CREATE USER username FOR LOGIN loginname;
GO