Configure Powershell/Run Powershell/Create Databases

Make sure you have the CreateDGSCIDatabases.ps1 file.
The CreateDGSCIDatabases.ps1 (powershell) file contains default names for the servers used in the installation process. This procedure walks through the process of changing these names to match the name of URL of your server.
Note: All examples and screen shots in this procedure reference SQL Management Studio.
  1. In the CreateDGSCIDatabases.ps1 file, search and replace the following with the name or URL of the desired server and replace
    • Dbhost
    • Admin host
    • coreServicesHostName
    • webhelpHostName
  2. In the Admin\DBInstaller folder, run the CreateDGSCIDatabases.ps1 script.
    Note: The script will create the IdentifyServerConfiguration, OspreyAuth, and OspreyApp databases.
  3. Open your database server and add a database that will be used with Document Generation Services (for example: docgen).
  4. Under Security/Logins, verify “NETWORK SERVICE” is listed and "sysadmin" is added to the server role.
  5. In "NETWORK SERVICE," select User Mappings.
  6. Select the following databases:
    • ASPState
    • docgen
    • IdentityServerConfiguration
    • OspreyApp
    • OspreyAuth
  7. Verify the role "db_owner" is added to the databases above.
WKFS