This documentation supports the 3.5 version of BMC Digital Workplace. To view the latest version, select the version from the Product version menu.

Pre-creating a Microsoft SQL database

This topic provides the steps to pre-create Microsoft SQL database.

Note

BMC Digital Workplace and Remedy with Smart IT require 20 MB for each schema.

Before you begin

Complete the BMC Digital Workplace and Smart IT installation worksheets.

To pre-create a Microsoft SQL database

  1. Log on to your Microsoft SQL Server database server machine. 

  2. Open the Microsoft SQL Server Management studio. 

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

    Note

    • Ensure that the User and Login has the same name in the script, for example <Domain name\user name>
    • If you want to change Openfire database password, ensure that the password does not contain the following characters: @, !, %, &
    USE master
    GO
    CREATE DATABASE SmartIT
    GO
    use SmartIT
    GO
    CREATE LOGIN openfire WITH PASSWORD = N'SmartIT',DEFAULT_DATABASE=[SmartIT], CHECK_EXPIRATION=off,CHECK_POLICY=off
    GO
    CREATE LOGIN SmartIT_System WITH PASSWORD = N'SmartIT', DEFAULT_DATABASE=[SmartIT], CHECK_EXPIRATION=off,CHECK_POLICY=off
    GO
    CREATE LOGIN SmartIT_Business WITH PASSWORD = N'SmartIT', DEFAULT_DATABASE=[SmartIT], CHECK_EXPIRATION=off,CHECK_POLICY=off
    GO
    CREATE USER openfire from LOGIN openfire
    GO
    CREATE USER SmartIT_System from LOGIN SmartIT_System
    GO
    CREATE USER SmartIT_Business from LOGIN SmartIT_Business
    GO
    CREATE SCHEMA openfire AUTHORIZATION openfire
    GO
    CREATE SCHEMA SmartIT_System AUTHORIZATION SmartIT_System
    GO
    CREATE SCHEMA SmartIT_Business AUTHORIZATION SmartIT_Business
    GO
    ALTER USER openfire WITH DEFAULT_SCHEMA = openfire
    GO
    ALTER USER SmartIT_System WITH DEFAULT_SCHEMA = SmartIT_System
    GO
    ALTER USER SmartIT_Business WITH DEFAULT_SCHEMA = SmartIT_Business
    GO
    GRANT CONNECT,CREATE TABLE,CREATE SCHEMA TO openfire
    GO
    GRANT CONNECT,CREATE TABLE,CREATE SCHEMA TO SmartIT_Business
    GO
    GRANT CONNECT,CREATE TABLE,CREATE SCHEMA TO SmartIT_System
    GO
  4. Execute the script. 

  5. On your installation worksheet, write the database name, users, and, passwords, which you have created using the script.

Replace the credentials in the database information screen with the  pre-created credentials. You can use the business credentials. For more information, see BMC Digital Workplace and Smart IT installation worksheets.

Where to go from here

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

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

Comments