Problem:
I want to create a user, or a login to connect to SQL server. I want this user to have the role of Admin.
Solution
Create Login [Your_User_Name] with password = 'The Password'
EXEC master..sp_addsrvrolemember @loginame = N'Your_User_Name', @rolename = N'sysadmin'
Create a login for SQL Server Done.