Skip to end of banner
Go to start of banner

Using the Database Configuration Wizard

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 6 Next »

  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;)


  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


  5.  Enter the proxy details (if necessary) and click Next
    1. Proxy Server Required: Tick this checkbox if a proxy server is required to access the questionnaire server (https://eppoc.ahsri.uow.edu.au/redcap/)
    2. Proxy Server: Enter the proxy server URL
    3. Port: The port of the proxy server
    4. Requires authentication: Tick this checkbox if the proxy server requires a username and password to function properly
    5. Username: The username for proxy authentication
    6. Password: The password for the above username
  6. Enter in the details for the administrator user and click Next
    1. Please note username and password and provide them to the service staff so they can use it to create their own accounts
  7. Enter the facility and token information provided by ePPOC for your service and click Next
    1. All of the values have been provided to your service by ePPOC and must be entered as is so as to match the data on our end
  8. Click Close and you're all done!
  • No labels