CREATE LOGIN YourUserName
    WITH PASSWORD = 'a strong password';
GO
CREATE USER YourUserName FOR LOGIN YourUserName;
GO