Pre-creating a Microsoft SQL database
This topic provides the steps to pre-create Microsoft SQL database.
BMC Digital Workplace and Remedy with Smart IT require 20 MB for each schema.
Before you begin
To pre-create a Microsoft SQL database
Log on to your Microsoft SQL Server database server machine.
Open the Microsoft SQL Server Management studio.
Click on New Query.
Update the script as per your business credentials before running.
- 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
Execute the script.
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.