Page Comparison

1. No mandatory password change policy for accounts in this database
2. Database name should involve the word epiCentre, if possible

1. The table structure scripts must come before the data scripts
2. Scripts can be found here

Determine a prefix to user with your SQL logins

Create a user with PREFIX_dbo, PREFIX_user, PREFIX_reader
1. Please note that the login creation script needs to be manually edited before being run
1. Install epiCentre on the first computer via the installation instructions provided here
2. Choose Yes when asked if the database is already configured and click Next

   Anchor
   configWizard configWizard

   
   
   
   
3. Choose SQL Server as the database type and click Next
   
4. Enter in the appropriate details for the existing database and click Next
   1. Server: The URL for your SQL Server instance
   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 were linked to this database (i.e. epiCentre prefix means epiCentre_dbo, epiCentre_reader, epiCentre_user)
   5. Owner password: The password for the db_owner user account
   6. User password: The password for the db_datareader and db_datawriter user account
   7. Reader password: The password the db_datareader user account
   8. Encrypt connection: Tick this checkbox if you want to encrypt the connection to the database (i.e SSL)
   9. 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
   10. Multi Subnet Failover: Tick this checkbox if your SQL Server is set up in a failover cluster configuration
   11. 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;)
       
       
       
5. 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
      
      
      
6.  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
      
      
      
7. 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
      
      
      
8. 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
      
      
      
9. Click Close and you're all done!