Microsoft SQL Server

To create a database on an existing Microsoft SQL Server database server, please use this SQL and adjust it to your needs:

-- ---------
-- USU PORTAL
-- ---------

USE master;
IF NOT EXISTS (SELECT name FROM master.sys.server_principals WHERE name = N'usu_portal')
       CREATE LOGIN [usu_portal] WITH PASSWORD = N'password', CHECK_POLICY = OFF
CREATE DATABASE usu_portal COLLATE Latin1_General_100_BIN2;
GO

USE [usu_portal];
CREATE USER usu_portal FOR LOGIN usu_portal;
EXEC sp_addrolemember 'db_datareader', 'usu_portal';
EXEC sp_addrolemember 'db_datawriter', 'usu_portal';
EXEC sp_addrolemember 'db_ddladmin', 'usu_portal';
GO

USE master;