Video Screencast Help

Installing Symantec Endpoint Protection on SQL server 2005 default instance

Created: 26 Aug 2009 • Updated: 21 May 2010 | 6 comments
ctrlq's picture
This issue has been solved. See solution.

Hi Everyone!

In the Installation Guide page 63 indicate the following: Instance Name: Do not use the default name. Create a name such as SEPM.

The problem is that i have a customer, that cannot create an additional instance name for administrative and cost reasons.

The only way that symantec recommend to install SEPM with SQL is on different instance that the default instance?. Please Confirm this answer with the reasons for this type of deployment.

Thanks Ind Advance,


Comments 6 CommentsJump to latest comment

kavin's picture

You can try to use your existing database instance name & see if that work but I have always used it with a new instance name Check this document

P_K_'s picture

Best Practices guide for Installing the Symantec Endpoint Protection Manager with a SQL Server 2005 Database

An existing database must define file groups PRIMARY, FG_CONTENT, FG_LOGINFO, FG_RPTINFO, and FG_INDEX. The user account for database access must have privileges db_ddladmin, db_datareader, and db_datawriter. If these requirements are not met, your installation fails. So it is adviced to create a  new instance .
A best practice is to define a new database.

MCT MCSE-2012 Symantec Technical Specialist (SCTS)'s picture

Dear List Members,

I have SEPM with SQL 2005 server install problem. I would like to establish some correlations in SSIM 4.6 between MS ISA server, SEPM and Windows event logs. In order to reach my goal I have to install SEPM with MS SQL 2005 server database. I have an MS Windows 2003 server (on a virtual machine) and an MS SQL 2005 server instance with client tools fortified with all features listed in Symantec install guide.I have already got SQL 2005 server install followed by the Symantec docs(SP3, suggested instance name =SEPM, SQL authentication mode is mixed, no case-sensitive SQL collocations, . . .)

During the SEPM with SQL 2005 database install procedure suddenly an error message turned up: semsvcres.dll could not be found.  None above of the mentioned error message said that the procedure went wrong. The install script was able to create the database, the data structure. I can confirm that the data structure in the database is correct as  far as I can know. I have tables and views, I can make queries on the database.

The message at the install procedure end said: the install procedure is succeeded, you can use your SEPM instance, . . . and so on.  Inspite of that I cannot log into the SEPM, I have failed to connect the server. The mentioned semsvcres.dll can be found on the machine at C:\Program Files\Symantec\Symantec Endpoint Protection Manager\bin\res\1033. I have no idea what could be the source of the problem and how to resolve  that.

Any fresh idea or suggestion would be warmly welcomed I have a strict deadline to solve the problem.

Laszlo +36 70 502 74 23

ctrlq's picture

For closing this question, Symantec provides support to a SEPM installation on a SQL Server with default instance? note:this post will show at the customer

ctrlq's picture

By default, a database named Sem5 is created in the SQL Server instance when you install the Symantec Endpoint Protection Manager. The default instance is unnamed. It is supported, but can cause confusion if you install multiple instances on one computer. pg 68, installation guide.