Create a tenant database to define a tenant.  A blank database can be created within SQL Server using SQL Server Management Studio or any other database management tool.  

On the Tenant Manager page, select the Utils - Create New Tenant DB menu. 

Choose how you prefer to create a new tenant database. Select the “Current Database Server or Connection String” button. Provide the new database name and click the “Create” button. 

Select the “Connection String” button and provide the connection string text as shown in the example below. 

Enable the “Connection String Builder” button. Enter the server and database names. Choose the authentication type (“SQL Server” or “Windows”). Enter the login credentials. Click the “Test” button to validate the connection. Click the “Generate” button to create the connection string syntax. 

In this example, we'll call it “FlowWrightTenant1.”  Click the “Create” button to create the new database. If successful, the database will be created on the same server as the current FlowWright database. If you would like to use a different database server, select the “Connection String” option and enter a connection string for another server.

Verify in SQL Server that the new database, “FlowWrightTenant1,” was created.

Note: The new tenant should also create the forms master script file. Navigate to C:\FlowWright\wwwroot\Tenants\GUID\js\formEvents to find the 'formWidget.js' file.

Next, add the tenant tables and data to this new database by navigating to the Utils - Create Tenant Tables & Data menu.

Provide the database name as “FlowWrightTenant1”. Choose how you prefer to create new tenant tables and data. Select the “Template or Existing Tenant” buttons. Click the “Create” button. 

Select the “Existing Tenant” option and choose the active tenant from the drop-down list. Click the “Create” button next.  

Once this operation succeeds, the new tenant database should contain the tables and configuration data the application requires.

You can verify the database tables and their data using a database management tool such as SQL Enterprise Manager.