Precreating a Microsoft SQL database

This topic provides the steps to precreate Microsoft SQL database.

Before you begin

Complete the BMC Digital Workplace and Smart IT installation worksheets.

To precreate 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 precreated 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.