FlowWright’s Workflow Database Creation Guide

Last published at: July 25th, 2023

FlowWright's default database is Microsoft SQL Server, FlowWright supports the following databases:

  • Microsoft SQL Server
  • Microsoft Azure 

Microsoft SQL Server Workflow Database Setup 

  1. If you don’t have a SQL server, download Microsoft SQL Server express for free using the following link
  2. Connect to the SQL Server instance using Enterprise Manager or Visual Studio
  3. Create a new database called "FlowWright"
  4. Execute the following database script file: FlowWright-MSSQLServer.sql from the directory: "C:\FlowWright\wwwroot\DBScript"
  5. Change the connection string within the file appSettings.json located at: C:\FlowWright

    *Do not change the connection key name “connectString”
  6. Make sure to restart Microsoft Internet Information server (IIS)
  7. Make sure to start the FlowWright engine services


Windows Azure Database Setup

  1. If you do not have a Microsoft Azure, please signup using the following link
  2. Connect to the Microsoft Azure instance using Enterprise Manager or Visual Studio
  3. Create a new database called "FlowWright"
  4. Execute the following database script file: FlowWright-MSAzure.sql from the directory: "C:\FlowWright\wwwroot\DBScript\"
  5. Change the connection string within the file appSettings.json located at: "C:\FlowWright\wwwroot\DBScript\" 

    *Do not change the connection name “connectString”
  6. Make sure to restart Microsoft Internet Information server (IIS)
  7. Make sure to start the FlowWright engine services

* Ensure that the user who will be accessing the database has the necessary database owner (db_owner) and schema owner permissions.