Set up and configure EWA to use Azure SQL Databases

EzeScan WebApps supports Microsoft SQL Server and by extension Azure SQL.

Create the SQL Database Server

1. Log into the Azure Portal and select the SQL servers option.
   

   

2. Click the Create button in the top left.
   

   

3. Enter the details for your SQL server and click Review + Create.
   

   

4. Review the settings and click the Create button.
   

   

5. Wait for the SQL Server to be deployed.
   

   

6. Once the deployment is complete click Go to resource.
   

   

Allow network traffic from EWA to Azure SQL server

This documentation covers talking to the Azure SQL server over a public IP address. Where possible using a virtual network to keep traffic off the internet is preferable.

1. Navigate to your Azure SQL server in Azure Portal.
2. On the left menu select the Firewalls and virtual networks option.
   

   

3. Set Allow Azure services and resources to access this server to Yes.
4. Add a rule with the IP address of your EWA Server that will connect to the Azure SQL server.
   

   

5. Click the Save button.
   

   

Create the databases

EzeScan WebApps requires 4 databases to be created:

ezescan.webapps.indexing.event
ezescan.webapps.indexing.read
ezescan.webapps.indexing.processManager
ezescan.webapps.indexing.files

Please repeat the process below for each database.

1. Navigate to your Azure SQL server in Azure Portal.
2. Click Create database
   

   

3. Enter the Database name and configure the additional settings you require.
   

   

4. Click the Review + Create button.
   

   

5. Review your settings and then click Create.
   

   

6. Once the deployment is finished click Go to resource.
   

   

7. Click the Show database connection strings link.
   

   

8. Copy the connection string using the copy to clipboard button and save it somewhere safe for future use in the next steps.
   

   

Configure EWA to use the Azure SQL databases

1. Stop IIS.
2. Navigate to the installation directory of EWA.
3. Locate the appsettings.template.json file and copy it to appsettings.json
   

   

4. Open the appsettings.json in a text editor and remove the underscore in front of the word apps.
   

   

   

5. Find and adjust the 4 connection strings using the values copied from the Azure portal in the previous step. 

   

   Be sure to replace {your_password} with the actual password for the user you created when setting up the Azure SQL server.

   Example Connection String

   CODE

   "connectionString": "Server=tcp:ewa-demo-sql.database.windows.net,1433;Initial Catalog=ezescan.webapps.indexing.event;Persist Security Info=False;User ID=ewa-dba;Password={your_password};MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;"

6. Start IIS and then load the EzeScan webpage. Confirm the page loads without errors and then confirm in SQL Server Management Studio that the databases have been created.