What steps are needed to create a new SQL login user?

Right-click the Security folder, select New Login, enter a login name (e.g., 'xpoda') and password, optionally uncheck Enforce password policy, then proceed to Server Roles and User Mapping.