Crear base de datos y usuario por comandos en SQL Server

La base de datos, login y usuario pueden ser creados con el SQL Server Management Studio con solo unos pocos clics. Sin embargo, yo prefiero usar comandos (SQLCMD), este es un ejemplo básico.

USE [master]
GO
-- Very basic DB creation
CREATE DATABASE [REDMINE]
GO
-- Creation of a login with SQL Server login/password authentication and no password expiration policy
CREATE LOGIN [REDMINE] WITH PASSWORD=N'redminepassword', DEFAULT_DATABASE=[REDMINE], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFFGO

-- User creation using previously created login authentication
 
USE [REDMINE]
GO
CREATE USER [REDMINE] FOR LOGIN [REDMINE]
GO
 
-- User permissions set via roles
 
EXEC sp_addrolemember N'db_datareader', N'REDMINE'GO
EXEC sp_addrolemember N'db_datawriter', N'REDMINE'GO

Y voilà!