Precreating a Microsoft SQL database

Before you begin

Complete the Installation-worksheets-for-BMC-Digital-Workplace.

To precreate a Microsoft SQL database

1. Log on to your Microsoft SQL Server database server. 
2. Open the Microsoft SQL Server Management studio. 

3. Click on New Query.
   Update the script with your business credentials before running.

   Warning

   Note

   • Ensure that the User and Login has the same name in the script, for example domainName\userName>.
   • BMC Digital Workplace supports collations with the "_CI" flag only.

   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
4. Execute the script. 
5. On your installation worksheet, write the database name, users, and passwords that you created using the script.

6. 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-BMC-Digital-Workplace.

   

Where to go from here

Make sure that you have completed the remaining steps in Preparing-for-installation-of-BMC-Digital-Workplace.