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


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



McAfee VirusScan


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.


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



Review Log




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.


    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



Access Protection Properties



Rule Details – Original



Rule Details – Upon adding DatabaseMail90.exe



Rule Details – Upon adding ReportingServicesService.exe


SQL Server – Antivirus – Exception Configuration – McAfee


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



  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


Set Exclusions – Post




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


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

from   master.dbo.sysaltfiles tblSAF

group by

	right(tblSAF.filename, 3)


  1. Recommended exclusions for VirusScan Enterprise on Microsoft SQL Servers