This documentation supports the 19.02 version of Remedy with Smart IT.

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

Creating Microsoft SQL database for a Smart IT upgrade


Note

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:

Note

Remedy with Smart IT requires 20 MB for each schema.

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

  2. Open the Microsoft SQL Server Management studio. 

  3. Click New Query.
    Update the script according to your business credentials before running it.

    Note

    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
  4. Run the script. 

  5. 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.


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

Comments