Setting up SQL Server

Migrating existing indexing items is currently in testing. Our support team is able to assist with migrating old data.
Otherwise please ensure you have processed all files in all indexing pages before migrating as old data will not be moved.

Supported Versions:

• Microsoft SQL Server 2022, 2019
• Microsoft SQL Server Express 2022, 2019

Step-by-step guide

SQL Server Installation and Permissions

1. If not installed, SQL Express and SQL Server Management Studio (SSMS) can be downloaded from https://www.microsoft.com/en-us/sql-server/sql-server-downloads
2. Install using defaults (local and default named instance)
3. Open SMSS and connect to your SQL server.
   

   

4. Right click on Security > Logins and select New Login
   

   

   
   

5. Find the name of the AppPool in IIS that runs EWA and then enter "IIS APPPOOL\AppPoolName".

   

   Important! Do not click the Search... button

   

   
   
   

6. Select the Server Roles option on the left and then tick the dbcreator server roll.
   

   

7. Click the Ok button.
   

   

Configuring EzeScan WebApps to use the local default named instance of SQL Server

1. Stop IIS.
2. Navigate to the isntallation 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
5. To convert RIA from using SQLite to SQL Server, you will need to remove the underscore in front of the word apps.
   

   

   
   
6. To convert DFA from using SQLite to SQL Server, you will need to remove the underscore in front of the word forms.

   

7. Save the changes, and close the appsettings.json file.
8. Start IIS and then load the EzeScan WebApps webpage. Confirm the page loads without errors and then confirm in SQL Server Management Studio that the databases have been created. 

9. 

Configuring EzeScan WebApps to use an SQL Server on another host

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 connection strings. 
   There is two ways to authenticate against a remote SQL server.

   1. Use Windows Authentication by configuring your IIS App Pool to run as a windows domain service account and then grant that account access to the MS SQL server in SQL Server Management Studio.

      Example Connection String

      SQL

      "connectionString": "Server=SERVER.DOMAIN.COM;Database=ezescan.webapps.indexing.event;Integrated Security=true;TrustServerCertificate=True"

   2. Use SQL Authentication and pass in a username and password in the connection string.

      Example Connection String

      CODE

      "connectionString": "Server=SERVER.DOMAIN.COM;Database=ezescan.webapps.indexing.event;User Id=myUsername;Password=myPassword;TrustServerCertificate=True"

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.