create database db9pm2c
on PRIMARY 
(  
    NAME = 'db9pm2c',  
    FILENAME='{{SQL_PATH}}\db9pm2c.mdf',  
    SIZE = 10,  
    MAXSIZE = UNLIMITED,  
    FILEGROWTH = 5  
)  
LOG ON 
(  
    NAME='db9pm2c_log',  
    FILENAME='{{SQL_PATH}}\db9pm2c.ldf',  
    SIZE =5MB,  
    MAXSIZE = 25MB,  
    FILEGROWTH =5MB  
) 
go

CREATE LOGIN [9pm2] WITH PASSWORD=N'{{SQL_PWD}}', DEFAULT_DATABASE=[db9pm2c], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
go

use db9pm2c
go

CREATE USER [9pm2] FOR LOGIN [9pm2] WITH DEFAULT_SCHEMA=[dbo]
exec sp_addrolemember 'db_owner', '9pm2'
go