Creating Microsoft SQL database for a Smart IT upgrade

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.