Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

Determine Database Type

Created: 11 Jun 2012 • Updated: 29 Jun 2012 | 7 comments
This issue has been solved. See solution.

I've acquired the management of our Symantec Endpoint Protection Management System.  The previous tech was fired on the spot.  Is their a quick way to determine if the Managers were set up using the default database or if it points to a MS Sql Server Database?  Perhaps in the console or a config file somewhere?  If there is a password set for a Sql Server Database, it left with the fired tech!

Total Endpoints: 4800
Licensed for: 9000

I'm running Version 12.1.1000.157 RU1

Three Virtual 2008 R2 Servers with SEPM on each, 1 where SEPM will not launch (failed to connect to server).
Each with 60GB C: drive -  Only 15GB Remaining on each.
Each with a 100GB D: drive - 2 Servers have with 100% free space, 1 Server 58GB free space remaining

One Virtual 2003 SP2 LiveUpdate Server - 40GB HD running low on space - 2GB free

Thanks!
Tony

Comments 7 CommentsJump to latest comment

AravindKM's picture

Under \Symantec\Symantec Endpoint Protection Manager folder are you able to find a DB folder, if yes it is using default database

How to find the Database password for Embedded Database

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

P_K_'s picture

If embedded (Sybase) database is used you will see dbsrv9.exe" process running in TASK MANGER and is listening on TCP port 2638

It can alos be checked in ODBC MMC

If Embedded login id will be dba

  1. Click Start> Control Panel
  2. Open Administrator Tools
  3. Double-click Data Sources (ODBC)
  4. Select the System DSN tab
    1. Double-click the SymantecEndpointSecurityDSN and go through the wizard to ensure the following settings:
    2. Name: SymantecEndpointSecurityDSN
  • Description:<Anything>
  • Server: Servername\InstanceName (Can be blank as it is localized, otherwise specify default "sem5")
  • Login ID: dba

  • Password: <password>
     

If SQL the login id will be sa

  1. Click Start> Control Panel
  2. Open Administrator Tools
  3. Double-click Data Sources (ODBC)
  4. Select the System DSN tab
    1. Double-click SymantecEndpointSecurityDSN and go through the wizard to ensure the following settings:
    2. Name: SymantecEndpointSecurityDSN
    • Description:<Anything>
    • Server: Servername\InstanceName (Only enter the server name or IP address if using the default instance)
    • Login ID: sa

    • Password: <password>

MCT MCSE-2012 Symantec Technical Specialist (SCTS)

Simpson Homer's picture

go to Start and then Run and then type Services.msc and check under Symantec if you could see Symantec Embedded database services.

Chetan Savade's picture

Hi Mrdaytrade,

Embedded database support upto 5000 clients per SEPM.

If Embedded database is used you will see "dbsrv11.exe" process running in task manager not "dbsrv9.exe".

Start --> Run --> Services.msc and check if you could see Symantec Embedded database services.

If it's not present then you will be using SQL database.

On virtual server you have only 2 GB free space, could you please make sure how much space is occupied by Symantec LUA on the same drive?

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.<

sandra.g's picture

If you can log into one of the three SEPMs, the quickest way to determine what type of DB you have is to log in to the SEPM then navigate to Admin > Servers. Under Local Site, you'll see an icon for servername and another for the database (it may say 'localhost'). If you click on that bottom icon, the right pane should display Database Server information. Type is one of the values listed.

Good luck,

sandra

Symantec, Senior Information Developer
Enterprise Security, Mobility, and Management - Endpoint Protection

Don't forget to mark your thread as 'solved' with the answer that best helps you!

Chetan Savade's picture

Hi Mrdaytrade,

Screenshot is attached for your reference.

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.<

SOLUTION