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

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

Creating the Microsoft SQL database

Creating a database is a part of preparing for installation process. The following procedure details the steps to create Microsoft SQL database:

Before you begin

Make sure that the database server has 20 MB free for each schema.

To create the Microsoft SQL database

  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.

    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 the 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. 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 that you created.

For more information, see Smart IT installation worksheets.

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

Comments