Unable to download quarantined items from SEPM

Products

• Endpoint Protection

Issue/Introduction

When trying to download the quarantined items from the SEPM console, nothing happens - the window is blank

Everything else is working fine.

You see the following entries in the reporting.log (%SEPM%\apache\logs) :

2023-01-25 12:24:21      ERROR:runcommand [DownloadQuarantine] > failed to connect to the database

Environment

SEPM 14.3 RU2 and newer with SQL database configured with Windows Authentication or Mixed authentication 

Cause

When the DB instance name start with lower case "e" (i.e.: SQLserver.domain.net\endpoint) , PHP treats it as a special character . 
Consequently, the connection to the database fails.

Resolution

There are to options to resolve this issue:

1. Change the SQL SEPM DB's instance name to a different name which does not start with lower case "e" and then run the Management Server Configuration Wizard to reconfigure the connection
   
   or
   
   
2. Locate and backup the Reporter2.php file ( %SEPM%\Php\Include\Resources ), then modify the following line (using the above example)
   
   $dbserver="SQLserver.domain.net\endpoint";
   to
   $dbserver="SQLserver.domain.net\\endpoint";
   
   

Additional Information

Reference to this behavior - https://stackoverflow.com/questions/6512104/whats-the-intention-of-e