Sidebar
+2 votes
91 views
by rich-c-2789 (17.6k points)

1 Answer

+1 vote
 
Best answer

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

by rich-c-2789 (17.6k points)
edited by rich-c-2789
...