To Create Login

--windows authentication:
--single user mapping:
CREATE LOGIN [instance_name] FROM WINDOWS
GO
--group mapping:
CREATE LOGIN [instance_name] FROM WINDOWS
--builtin administrator mapping:
CREATE LOGIN [instance_name] FROM WINDOWS

--sql authentication:
CREATE LOGIN [loginname] WITH PASSWORD=N'[password]'
GO