Precreating a Microsoft SQL database
This topic provides the steps to precreate Microsoft SQL database.
BMC Digital Workplace requires 20 MB for each schema.
Before you begin
Complete the Installation worksheets for Digital Workplace.
To precreate a Microsoft SQL database
Log on to your Microsoft SQL Server database server.
Open the Microsoft SQL Server Management studio.
Click on New Query.
Update the script with your business credentials before running.
Ensure that the User and Login has the same name in the script, for example domainName\userName>.
USE master GO CREATE DATABASE DWP GO use DWP GO CREATE LOGIN DWP_System WITH PASSWORD = N'DWP', DEFAULT_DATABASE=[DWP], CHECK_EXPIRATION=off,CHECK_POLICY=off GO CREATE LOGIN DWP_Business WITH PASSWORD = N'DWP', DEFAULT_DATABASE=[DWP], CHECK_EXPIRATION=off,CHECK_POLICY=off GO CREATE USER DWP_System from LOGIN DWP_System GO CREATE USER DWP_Business from LOGIN DWP_Business GO CREATE SCHEMA DWP_System AUTHORIZATION DWP_System GO CREATE SCHEMA DWP_Business AUTHORIZATION DWP_Business GO ALTER USER DWP_System WITH DEFAULT_SCHEMA = DWP_System GO ALTER USER DWP_Business WITH DEFAULT_SCHEMA = DWP_Business GO GRANT CONNECT,CREATE TABLE,CREATE SCHEMA TO DWP_Business GO GRANT CONNECT,CREATE TABLE,CREATE SCHEMA TO DWP_System GO
Execute the script.
On your installation worksheet, write the database name, users, and passwords that you created using the script.
On the database information screen of the installer, replace the credentials with the precreated credentials.
You can use the business credentials. For more information, see Installation worksheets for Digital Workplace.
Where to go from here
Make sure that you have completed the remaining steps in Preparing for installation of Digital Workplace.