This post is just basically a SQL snippet for you to copy, paste and edit for use when you need to create a SQL database with a login and a user.
I use it when creating databases for Umbraco websites.
Just do a find and replace for 'mydatabase' with whatever you want to call your database and change the password of course!
USE master
GO
CREATE DATABASE [mydatabase]
CREATE LOGIN [mydatabase-login] WITH password='supersecretpassword1=';
USE [mydatabase]
GO
CREATE USER [mydatabase-user] FROM LOGIN [mydatabase-login];
EXEC sp_addrolemember 'db_datawriter', 'mydatabase-user'
EXEC sp_addrolemember 'db_ddladmin', 'mydatabase-user'
EXEC sp_addrolemember 'db_datareader', 'mydatabase-user'