Versions Compared

Old Version 4

changes.mady.by.user Branden Maynes (Unlicensed)

Saved on

compared with

New Version 5

changes.mady.by.user Branden Maynes (Unlicensed)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
  1. Choose No when asked if the database is already configured and click Next


  2. Enter in the appropriate values for the connection to the database server and click Next
    1. Server: The URL for your SQL Server instance
    2. Authentication mode: SQL Server login uses a username and password, Integrated security uses the currently logged in user's AD privileges
    3. Database administrator: Username of the SQL Server account that has elevated privileges for creating/editing database
    4. Administrator password: Password for the above account
    5. The DB Admin Username and password are not stored anywhere within epiCentre and are only used for the initial setup process


  3. Enter in the appropriate details for the new database and click Next
    1. Server: Same as previous screen, and should be pre-filled
    2. Database: The name of the database you want to create (i.e. epiCentre)
    3. Authentication mode: SQL Server login uses a username and password, Integrated security uses the currently logged in user's AD privileges
      1. If you choose Integrated security, please be aware that this requires that all users of epiCentre have the same elevated privileges in SQL Server
    4. Username prefix: The prefix for the SQL Logins that will be created (i.e. epiCentre prefix means epiCentre_dbo, epiCentre_reader, epiCentre_user)
    5. Owner password: The password for the db_owner user account. Please enter the password in again in the second text box
    6. User password: The password for the db_datareader and db_datawriter user account. Please enter the password in again in the second text box
    7. Reader password: The password the db_datareader user account. Please enter the password in again in the second text box
    8. Database file path: This is the path for the actual database file. This path must be a directory that SQL Server has read/write privileges in.
    9. Encrypt connection: Tick this checkbox if you want to encrypt the connection to the database (i.e SSL)
    10. Trust server certificate: Only available if you ticked Encrypt connection; tick this checkbox if you want epiCentre to trust the certificate provided on the database server, without checking it against a signing authority
    11. Multi Subnet Failover: Tick this checkbox if your SQL Server is set up in a failover cluster configuration
    12. Additional connection properties: If you need more connection options that aren't provided, use this space to add whatever you need (i.e. Network Library=DBMSSOCN;MultipleActiveResultSets=true;)

     Next screen

  4.  Enter the encryption key for your database and click Next
    1. The encryption key is not provided by ePPOC and should be decided upon by the service or IT, and noted somewhere where it won't be lost/deleted
      Image Added