FlowWright’s Workflow Database Creation Guide

Last published at: January 1st, 2025

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 the 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 sign in 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 the 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 permissions for the necessary database owner (db_owner) and schema owner.