Creating Microsoft SQL database for a Smart IT upgrade
This procedure is not required if you are upgrading Smart IT from 18.05 to the latest version.
Due to the separation of BMC Digital Workplace and Smart IT products, during the Smart IT upgrade, you must create new DB schemas. The new DB schemas will contain only Smart IT data. Creating a database is a part of preparing for upgrade process.
Remedy with Smart IT (Smart IT) installer will create the new DB schemas automatically. However, if you have database access restrictions and cannot allow the Smart IT installer to create schemas, you can create a pre-existing schemas.
The following procedure details the steps to create Microsoft SQL database schemas:
Remedy with Smart IT requires 20 MB for each schema.
Log on to your Microsoft SQL Server database server machine.
Open the Microsoft SQL Server Management studio.
Click New Query.
Update the script according to your business credentials before running it.
Ensure that the User and Login has the same name in the script, for example <Domain name\user name>
use master GO use SmartIT GO CREATE LOGIN SmartIT_System_New WITH PASSWORD = 'SmartIT', DEFAULT_DATABASE=[SmartIT], CHECK_EXPIRATION=off,CHECK_POLICY=off GO CREATE LOGIN SmartIT_Business_New WITH PASSWORD = 'SmartIT', DEFAULT_DATABASE=[SmartIT], CHECK_EXPIRATION=off,CHECK_POLICY=off GO CREATE USER SmartIT_System_New from LOGIN SmartIT_System_New GO CREATE USER SmartIT_Business_New from LOGIN SmartIT_Business_New GO CREATE SCHEMA SmartIT_System_New AUTHORIZATION SmartIT_System_New GO CREATE SCHEMA SmartIT_Business_New AUTHORIZATION SmartIT_Business_New GO ALTER USER SmartIT_System_New WITH DEFAULT_SCHEMA = SmartIT_System_New GO ALTER USER SmartIT_Business_New WITH DEFAULT_SCHEMA = SmartIT_Business_New GO GRANT CONNECT,CREATE TABLE,CREATE SCHEMA TO SmartIT_Business_New GO GRANT CONNECT,CREATE TABLE,CREATE SCHEMA TO SmartIT_System_New GO
Run the script.
On your installation worksheet, write the database name, users, and passwords that you have created using the script.
Replace the credentials in the database information screen with the business credentials. For more information, see Smart IT installation worksheets.