Open SQL Server and login with a user that has privileges to create databases/users
In the Object Explorer, right-click on the Databases folder, and click New Database
Fill out the details as IT standards dictate, with the following caveats
1. No mandatory password change policy for accounts in this database
2. Database name should involve the word epiCentre, if possible
Open the New Query window and run the scripts for the table structure and the data
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 logins and map them to roles/users in the database via the scripts here, ensuring that the logins you create are PREFIX_dbo, PREFIX_user, and PREFIX_reader, where PREFIX is a value consistent across the 3 logins
1. Please note that the login creation script needs to be manually edited before being run
Install epiCentre on the first computer via the installation instructions provided here
Choose Yes when asked if the database is already configured and click Next
Choose SQL Server as the database type and click Next
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;)
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
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
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
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
Click Close and you're all done!

Browser not supported