To create a dabase for QIE version .47 or later licensed for High Availability, please see this question: SQL Server script to create High Availability database for QIE
This question creates a database for stand alone QIE.
This script uses qie for the database name and user name. Which is the default. Comments in the script are added to add claification.
-- Create a new database
-- dbName
CREATE DATABASE qie
GO
-- Create the qie user and map it to the qie database
-- userName
CREATE LOGIN qie
-- userName dbName
WITH PASSWORD='qie', DEFAULT_DATABASE=qie, DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF;
GO
-- Create a user in a database for a given login
-- dbName
USE qie;
GO
-- userName userName
CREATE USER qie FOR LOGIN qie WITH DEFAULT_SCHEMA=[dbo]
GO
-- Make the qie user a member of following groups
-- dbName
USE qie
-- userName
ALTER ROLE [db_backupoperator] ADD MEMBER [qie]
ALTER ROLE [db_datareader] ADD MEMBER [qie]
ALTER ROLE [db_datawriter] ADD MEMBER [qie]
ALTER ROLE [db_ddladmin] ADD MEMBER [qie]
ALTER ROLE [db_owner] ADD MEMBER [qie]
GO
USE qie
ALTER DATABASE CURRENT SET RECOVERY SIMPLE;
GO
