SQL Server – Mail – Anti-Virus ( McAfee VirusScan )

Background

On one of our MS SQL Server Instances, trying to get Database Job Email Notification going, but running into problems.

 

Virus

McAfee VirusScan

Telnet

I went a bit low level and reached for Telnet.

Things went well, no actual error messages.

SysAdmin Assist

Was clueless for a very long time.

And, then reached out to our SysAdmin and he said the problem could very well be mcAfee Virus Scan.

Logs

Launched McAfee \ VirusScan Console, and accessed the Logs via:

  1. From the list of Tasks, chose Access Protection
  2. And, right clicked on that selection
  3. From the drop-down menu, choose “View Log”

Trigger View Log

InitiateViewLog-Cropped

 

Review Log

AccessLog-20160722-1029AM

 

Processing

The change documented below is the one we had to make on the DB Server.  As local mcAfee configuration changes gets over-written by the one made on central server, please use this as a template and customize for central\global use.

Steps

    1. On MS Windows Desktop, from the Start menu, launch McAfee \ VirusScan Console
    2. In the VirusScan Console, from the list of Tasks, choose “Access Protection
    3. In the “Access Protection Properties” window
      • In the left panel, from the list of “Categories”, choose “Anti-Virus Standard Protection
      • In the right panel, from the list of “Rules”, choose “Prevent mass mailing worms from sending mail
      • Uncheck Block and Report
      • Click the “Edit” button
    4. The edit button activates the “Rules Details” window
      • In the “Processes to exclude”, please make that the following applications are included
        • DatabaseMail90.exe
        • ReportingServicesService.exe

 

GUI

Access Protection Properties

AccessProtectionProperties-AccessProperty-AVStandardProtection

 

Rule Details – Original

RuleDetails

 

Rule Details – Upon adding DatabaseMail90.exe

RuleDetails-DatabaseMail90-ex

 

Rule Details – Upon adding ReportingServicesService.exe

RuleDetails-ReportingServicesServiceDOTExe

SQL Server – Antivirus – Exception Configuration – McAfee

Background

A quick word on configuring McAfee AV for use on a Microsoft SQL Server system.

 

Steps

  1. Launch McAfee On-Access Scan
  2. The “On-Access Scan Properties” window appears
  3. From the left panel, click on the “All processes” icon (  AllProcesses )
  4. Click the “Exclusions” tab
  5. In the Exclusions tab, click the “Exclusions” button ( Exclusions )
  6. The “Set Exclusions” window appear
  7. Click the “Add button” ( AddButton   )
  8. The “Add Exclusion Item” window
  9. Click the “By file type (can include the ? wildcard ) option button
  10. Enter the standard file type/extension for Microsoft SQL Server files; which is mdf
  11. Click the OK button
  12. The “Add Exclusion Item” window closes, and we are returned to the “Set Exclusions” window
  13. Repeat by clicking the “Add button” to add other SQL Server files
    • LDF ( Log file)
    • NDF (Secondary data file )
    • BAK ( Database Backup )
    • LOG/TRN ( Database Transaction Backup )

 

Screen Shots

Set Exclusions – Pre

SetExclusions

Set Exclusions – Post

SetExclusions-Post

 

Code

Here is a short code snippet to identify file extensions in use on a SQL Server Instance


select 

          fileext = right(tblSAF.filename, 3)
	, [numberofFiles] = count(*)

from   master.dbo.sysaltfiles tblSAF

group by

	right(tblSAF.filename, 3)

References

  1. Recommended exclusions for VirusScan Enterprise on Microsoft SQL Servers
    https://kc.mcafee.com/corporate/index?page=content&id=KB67211