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

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s