Video Screencast Help

Exclusion for for SQL server

Created: 12 Aug 2013 | 12 comments

Hi ,

Please share some documents releated to SEP 12.1.x is support for SQL server 2005,2008.

Share any document releated to automatic exclusion for SQL

Note : 12.1.x

Thanks in Advance..

Manikandan K

Operating Systems:

Comments 12 CommentsJump to latest comment

Brɨan's picture

See here

Excluding Microsoft SQL Server files and folders using Centralized Exceptions

padding: 1px;padding-bottom: 3px ;font: 12px Arial; text-align: left;">Article:TECH105240 padding: 1px;font: 12px Arial; text-align: left;"> |  padding: 0px;font: 12px Arial; text-align: left;">Created: 2008-01-27 padding: 1px;font: 12px Arial; text-align: left;"> |  padding: 1px;font: 12px Arial; text-align: left;">Updated: 2012-11-12 padding: 1px;font: 12px Arial; text-align: left;"> |  padding: 1px;font: 12px Arial; text-align: left;">Article URL http://www.symantec.com/docs/TECH105240

Microsoft SQL Server 2012 supportibility with Symantec Endpoint Protection Manager

padding: 1px;padding-bottom: 3px ;font: 12px Arial; text-align: left;">Article:TECH200682 padding: 1px;font: 12px Arial; text-align: left;"> |  padding: 0px;font: 12px Arial; text-align: left;">Created: 2012-12-10 padding: 1px;font: 12px Arial; text-align: left;"> |  padding: 1px;font: 12px Arial; text-align: left;">Updated: 2013-03-19 padding: 1px;font: 12px Arial; text-align: left;"> |  padding: 1px;font: 12px Arial; text-align: left;">Article URL http://www.symantec.com/docs/TECH200682

Microsoft SQL Server 2008 R2 Support for Symantec Endpoint Protection Manager (SEPM) 11.x and 12.1

padding: 1px;padding-bottom: 3px ;font: 12px Arial; text-align: left;">Article:TECH138896 padding: 1px;font: 12px Arial; text-align: left;"> |  padding: 0px;font: 12px Arial; text-align: left;">Created: 2010-09-01 padding: 1px;font: 12px Arial; text-align: left;"> |  padding: 1px;font: 12px Arial; text-align: left;">Updated: 2012-08-03 padding: 1px;font: 12px Arial; text-align: left;"> |  padding: 1px;font: 12px Arial; text-align: left;">Article URL http://www.symantec.com/docs/TECH138896

Please click the "Mark as solution" link at bottom left on the post that best answers your question. This will benefit admins looking for a solution to the same problem.

Mithun Sanghavi's picture

Hello,

Symantec Endpoint Protection cannot scan the proprietary database files of MS SQL 2000, MS SQL 2005 or MS SQL 2008. To enhance performance and avoid any chance of corruption or files being locked when the SQL service must use them, administrators are recommended to create exclusions to prevent scanning of the directories containing these database files.

Microsoft's article has recommendations for exclusions for SQL (see the section entitled, "Directories and file-name extensions to exclude from virus scanning"):

How to choose antivirus software to run on computers that are running SQL Server

http://support.microsoft.com/kb/309422

Excluding Microsoft SQL Server files and folders using Centralized Exceptions

http://www.symantec.com/docs/TECH105240

Hope that helps!!

Mithun Sanghavi
Associate Security Architect

MIM | MCSA | MCTS | STS | SSE | SSE+ | ITIL v3

Don't forget to mark your thread as 'SOLVED' with the answer that best helped you.

Chetan Savade's picture

Hi,

Thank you for poting in Symantec community.

I would be glad to answer your query.

SQL 2005 and 2008 is supported by all SEP 12.1 versions & For SQL you will have to create manual exclusion if required.

Here is the landing page for all SEP 11.x & 12.1 Products system requirements.

Release Notes and System Requirements for all versions of Symantec Endpoint Protection and Symantec Network Access Control

http://www.symantec.com/docs/TECH163829

Automatic exclusions are not created for SQL. Automatic exclusion are created if SEP is installed on Microsoft Exchange and Active Directory Domain Controllers.

Refer this:

padding: 1px;padding-bottom: 3px ;font: 12px Arial; text-align: left;">Article:TECH105814 padding: 1px;font: 12px Arial; text-align: left;"> |  padding: 0px;font: 12px Arial; text-align: left;">Created: 2008-01-05 padding: 1px;font: 12px Arial; text-align: left;"> |  padding: 1px;font: 12px Arial; text-align: left;">Updated: 2011-03-02 padding: 1px;font: 12px Arial; text-align: left;"> |  padding: 1px;font: 12px Arial; text-align: left;">Article URL http://www.symantec.com/docs/TECH105814

Why SQL manual exclusion are required?

Check this:

To minimize the impact of SEP client AutoProtect and scheduled scans, exclude the folders housing Microsoft SQL Server database files.

Note: It is necessary to exclude the folders containing these files for maximum effectiveness. Folder based exclusions are processed before AutoProtect or scheduled scans access a file where file name or extension based exclusions are processed after the scan happens.

For more information on recommendations for Microsoft SQL server, read the following Microsoft article: How to choose antivirus software to run on computers that are running SQL Server.

Reference: http://www.symantec.com/docs/TECH105240

Chetan Savade
Sr.Technical Support Engineer, Endpoint Security
Enterprise Technical Support
CCNA | CCNP | MCSE | SCTS |

Don't forget to mark your thread as 'SOLVED' with the answer that best helps you.<

raghu.mc's picture

Hi,

I have SQL 2012 for SEPM 12.1.2. A few queries:

1. Is SQL 2012 fully supported?

2. SEMSVC.EXE Is takin 60% CPU usage. I checked the forums and turning off DEP is the solution. I am running on SQL 2012 in a seperate box. However, the articlue states it may cause security intrusions.

Please suggest!

raghu.mc's picture

Thanks for that pete. What about my other query? How to get around it?

pete_4u2002's picture

can you let us know the article you referring to.

pete_4u2002's picture

well you are not turning off except the apache is not included.

can you think of upgrade of SEPM.

raghu.mc's picture

We are planning to upgrade, but is this issue solved in RU4?

pete_4u2002's picture

are you seeing the same errors as reported in the article?

is it small business edition?

its good to upgrade the server.