Creating the Microsoft SQL database

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.