It is necessary to create a database at the SQL server to store system data.

System data is a set of tables that are to store system data.

Creating a database.
  1. Run SQL Server Management Studio and connect to the server, providing required credentials.
  2. Create a new database to store the Indeed AM system data.
    1. Expand your SQL server contents.
    2. Right-click the "Databases” item.
    3. Select "New Database” item.
  3. Enter the name for the new database and click "Ok".

Creating a user.

You have to create a service account and give it full access to the database in order for the system to work with the data storage.

The account named Admin-DB is created as an example. Screenshots below demonstrate the configuration process for this account.
  1. Expand the "Security” node at the SQL server. Right-click the "Logins” item. Select "New Login...” item.

  2. Perform the following actions at the main page:
    1. Set the new user name.
    2. Select the authentication method with SQL server.
    3. Deactivate mandatory change of password upon next login.
    4. Select your created database in the “Default database” item.
  3. Select the "sysadmin” role at the “Server roles” page.
The members of predefined sysadmin role can perform any actions at the server.


  • No labels