This documentation supports the 19.08 version of BMC Digital Workplace Basic.

To view the latest version, select the version from the Product Version menu.

Precreating a Microsoft SQL database

This topic provides the steps to precreate Microsoft SQL database.

Note

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

  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.

    Note

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

Where to go from here

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

Was this page helpful? Yes No Submitting... Thank you

Comments