Video Screencast Help
Symantec Appoints Michael A. Brown CEO. Learn more.

SEPM database on SQL Express

Created: 11 May 2010 • Updated: 12 Nov 2010 | 7 comments

Hello,

I have a couple of question about hosting the SEPM database in SQL Express.

Will the 4GB database size limit be an issue with 80-90 clients, and are there settings that can be configured to lower data usage, e.g. how long to keep historical client information.

Is SEPM tested/supported on the new SQL 2008 R2 Express?

Thanks in advance

Comments 7 CommentsJump to latest comment

pete_4u2002's picture

SQL express is not supported by SEPM.

The size of the DB is based on the maintainance and configuration for log/client restore.

FOr 80-90 clients you can go for inbuilt DataBase ( Sybase).

Vikram Kumar-SAV to SEP's picture

SQL express is not supported database for SEPM.

Read this doc for knowning the system requirements and what all are supported with SEPM

latest version 11.0.6
http://service1.symantec.com/SUPPORT/ent-security....

You can control the time period for logs.
SEPM-Admin-Servers-Local Site-Porperties-Database.

4 GB database size is more than enough for 80-90 clients. Even Embedded database will support that much.

Vikram Kumar

Symantec Consultant

The most helpful part of entire Symantec connect is the Search button..do use it.

AravindKM's picture

Officially in SQL express is not supported If no. of clients is less than 5000 you can go for embedded database which is coming along with SEPM software.

Please don't forget to mark your thread solved with whatever answer helped you : ) Thanks & Regards Aravind

Mudit Kumar's picture

SQL Express is not supported with Symantec Endpoint Protection Manager, below is the System Requirment Link that has information about all the supported Databases.

Title: 'System Requirements for Symantec Endpoint Protection and Symantec Network Access Control 11.0.6'
Web URL: http://service1.symantec.com/support/ent-security.nsf/docid/2010041307181848?Open&seg=ent

Embedded Database can be used for 80 to 90 Clients.

Thanks & Regards,
Mudit Kumar
 

goAtsy's picture

The reason I would like to use SQL Express instead of the embedded database is that I need SQL for other services on the same server, and I would prefer not to mix to many database engines on the same machine (it will run Firebird and SQL Express).

I understand that it's not officially supported but are there any known problems or tests made that indicates it shouldn't work. The express versions are afaik not different to the full versions except the restrictions (4GB Database, 1GB Memory, 1 CPU).

AravindKM's picture

I think you can give a try..

Please don't forget to mark your thread solved with whatever answer helped you : ) Thanks & Regards Aravind

pete_4u2002's picture

heard earlier, that the it still can be installed on SQL express, but when you log a case, you may not be entertained by support team.