Skip to end of banner
Go to start of banner

Using the database creation scripts

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 3 Next »

  1. Open SQL Server and login with a user that has privileges to create databases/users
  2. In the Object Explorer, right-click on the Databases folder, and click New Database
  3. 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
  4. 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

  5. Determine a prefix to user with your SQL logins

  6. Create logins and map them to roles 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
  7. Create a user with PREFIX_dbo, PREFIX_user, PREFIX_reader
  8. Choose Yes when asked if the database is already configured and click Next


  9. Choose SQL Server as the database type and click Next
  10. 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;)


  11. 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


  12.  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


  13. 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


  14. 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


  15. Click Close and you're all done!
  • No labels