fbpx

Company News

Antivirus Exclusions for SharePoint 2010 and SQL Server 2012

June 27, 2012

Much has been blogged about SQL Server 2008 / 2008 R2 Antivirus exceptions when using SharePoint 2010, but no one seems to have blogged the SQL Server 2012 exceptions.  That being the case, I figured I might as well be the one to do it.  Below you’ll find a list of all the files.

**Important Note** My installation was the BI edition of SQL 2012, as we had no need for (let alone license to) the enterprise edition.  As such, we had no particular need for SSAS or SSRS or High Availability (yes, all the BI tools you need for SharePoint 2010, when using SQL 2012, are included in the BI edition without having SSAS or SSRS installed on your SQL box).  We followed this up with an install of PowerPivot on the SharePoint 2010 server, which installed many of the SSAS components on that machine, so I am using the paths found on the SharePoint box in my assumptions below.  Be sure to set the exclusions on the correct machine (if you have SSAS / SSRS installed on your SQL box for some reason, turn the exclusions on there too).

Product

Description

Exclusion Type

Location

Comments

SQL 2012

Data Files

Extension

.mdf, .ldf, .ndf

Backup Files

Extension

.bak, .trn

Full-Text Catalog Files

Folder

Default instance:

Drive:\Program Files\Microsoft SQL Server\MSSQL\FTDATA

Or…

Named instance:

Drive:\Program Files\Microsoft SQL Server\MSSQL$<Instance Name>\FTDATA

SharePoint 2010 doesn’t require this to be turned on, so we did not enable it.  I’m assuming the value is accurate according to my source for this (based on the 2008 value).

Trace Files

Extension

.trc

SQL Audit Files Extension .sqlaudit For more info see: MSDN SQLAudit Info
SQL Query Files Extension .sql
SSAS Data and Temp Folder Folder Default:Drive:\Program Files\Microsoft SQL Server\MSAS11.<Instance Name>\OLAP\Data

This could be different and in separate places based on the configuration.

** For PowerPivot with SQL 2012, this will need to be set on your SharePoint machine, not SQL (unless you have SSAS installed on SQL as well)

SSAS Backup Folder Folder Default:Drive:\Program Files\Microsoft SQL Server\MSAS11.<Instance Name>\OLAP\Backup This could be different based on the configuration.** For PowerPivot with SQL 2012, this will need to be set on your SharePoint machine, not SQL (unless you have SSAS installed on SQL as well)
SSAS Log Folder Folder Default:Drive:\Program Files\Microsoft SQL Server\MSAS11.<Instance Name>\OLAP\Log This could be different based on the configuration.** For PowerPivot with SQL 2012, this will need to be set on your SharePoint machine, not SQL (unless you have SSAS installed on SQL as well)
SSAS additional folders Folder Any extra folders added for SSAS in addition to what’s above.

** For PowerPivot with SQL 2012, these may need to be set on your SharePoint machine

SQL Server Database Engine Process %ProgramFiles%\Microsoft SQL Server\MSSQL11.<Instance Name>\MSSQL\Binn\SQLServr.exe
SQL Server Reporting Services Process %ProgramFiles%\Microsoft SQL Server\MSSQL11.<Instance Name>\Reporting Services\ReportServer\
Bin\ReportingServicesService.exe

**Assuming 2008 value, with 2012 path.

SQL Server Analysis Services Process %ProgramFiles%\Microsoft SQL Server\MSSQL11.<Instance Name>\OLAP\Bin\MSMDSrv.exe
SQL High Availability [UNKNOWN for 2012] If you’re running antivirus on a SQL cluster, make sure the Antivirus product and version is cluster-aware.

 

Note: From what I can tell, these values are not yet officially sanctioned by Microsoft (I can find no reference to these anywhere, but I needed to start somewhere, so I started with the 2008 values and came up with the above values).

Note: The original (SQL Server 2008/R2) source for this is the following blog post:  http://spinplate.com/2012/02/antivirus-exclusions-for-sharepoint-2010-and-sql-server-2008-r2/ Many thanks to SpinPlate.  Please see the link for the remaining SharePoint 2010 exclusions (including Windows Server exclusions and SharePoint 2010 exclusions).

Leave a Reply

Colin Phillips

itgroove Alumni

Colin Phillips

Subscribe via Email

Categories

Powered by...

itgroove Corporate Profile
Connect With Us