TN 024: Configuring Antivirus Software for use with Dream Report
Summary
If antivirus software is installed, and/or a firewall enabled on a Dream Report server, certain exclusions and security settings should be configured for Dream Report to execute correctly. This tech note covers the recommended antivirus, firewall and security settings for Dream Report.
This document identifies the settings that need to be changed, but does not describe how to change these settings, as they are system/software-specific. We suggest you consult with your network administrator before performing any of these changes, or refer to your Windows documentation.
It is the reader’s responsibility to know the full path to the files listed below, and you must have administrative rights to the system in order to make these changes.
DCOM Global Settings
When communicating with any remote OPC server, Windows DCOM settings need to be properly configured. Please refer to one of these sources sites and documents to configure the DCOM settings:
Antivirus Exclusions for Dream Report
Directories and file name extensions to exclude from virus scanning
Anti-Virus software should not process files in the following Dream Report folders:
C:\ODS\Dream Report\ (your Dream Report may be installed on a driver other than the C: drive)
If your Dream Report project folder is not under the default folder (\ODS\Dream Report\Project), then that folder (and its sub-folders) needs to be excluded from antivirus scanning as well.
If using SQL Server for the Dream Report database folder, please refer to the Antivirus Exclusions for SQL Server section below.
Dream Report Processes to exclude from virus scanning
NOTE: The following application paths are the default paths. If you installed Dream Report in another drive or folder, please refer the folder where Dream Report is installed.
C:\ODS\Dream Report\System\Rtm.exe
C:\ODS\Dream Report\System Rmc.exe
C:\ODS\Dream Report\System\USC.exe
C:\ODS\Dream Report\System\Generator.exe
C:\ODS\Dream Report\System\LoggerRT.exe
C:\ODS\Dream Report\System\DR_CAIT.exe
Antivirus Exclusions for SQL Server
The following settings should be applied if using SQL Server for Dream Report project database:
Directories and file name extensions to exclude from virus scanning
When you configure your antivirus software settings, make sure that you exclude the following files or directories (as applicable) from virus scanning. This improves the performance of the files and helps make sure that the files are not locked when the SQL Server service must use them. However, if these files become infected, your antivirus software cannot detect the infection.
NOTE: For more information about the default file locations for SQL Server, go to the File Locations for Default and Named Instances of SQL Server topic on the Microsoft Docs website.
SQL Server data files - these files usually have one of the following file name extensions:
.mdf
.ldf
.ndf
SQL Server backup files – these files typically have one of the following file name extensions:
.bak
.trn
Full-Text catalog files
Default instance: Program Files\Microsoft SQL Server\MSSQL\FTDATA
Named instance: Program Files\Microsoft SQL Server\MSSQL$instancename\FTDATA
Processes to exclude from virus scanning
%ProgramFiles%\Microsoft SQL Server<Instance_ID>.<Instance Name>\MSSQL\Binn\SQLServr.exe
%ProgramFiles%\Microsoft SQL Server<Instance_ID>.<Instance Name>\Reporting Services\Report
Server\Bin\ReportingServicesService.exe%ProgramFiles%\Microsoft SQL Server<Instance_ID>.<Instance Name>\OLAP\Bin\MSMDSrv.exe