Create Login and user in SQL Server 2005

To Create a Login :

CREATE LOGIN [username] WITH PASSWORD=N'password', DEFAULT_DATABASE=[TestDB],
CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF


To Create a user:

CREATE USER [username] FOR LOGIN [login_name]