Endpoint Protection

 View Only
  • 1.  Determine Database Type

    Posted Jun 11, 2012 04:01 PM

    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



  • 2.  RE: Determine Database Type

    Posted Jun 11, 2012 04:24 PM

    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

     

     



  • 3.  RE: Determine Database Type

    Posted Jun 11, 2012 04:49 PM

    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><anything></anything>
    • Server: Servername\InstanceName (Can be blank as it is localized, otherwise specify default "sem5")
    • Login ID: dba

    • Password: <password></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><anything></anything>
      • Server: Servername\InstanceName (Only enter the server name or IP address if using the default instance)
      • Login ID: sa

      • Password: <password></password> <password>


     



  • 4.  RE: Determine Database Type

    Posted Jun 12, 2012 05:38 AM

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



  • 5.  RE: Determine Database Type

    Broadcom Employee
    Posted Jun 12, 2012 09:46 AM

    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?

     



  • 6.  RE: Determine Database Type

    Posted Jun 13, 2012 05:34 PM

    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



  • 7.  RE: Determine Database Type
    Best Answer

    Broadcom Employee
    Posted Jun 14, 2012 07:22 AM

    Hi Mrdaytrade,

    Screenshot is attached for your reference.



  • 8.  RE: Determine Database Type

    Posted Jun 29, 2012 08:42 PM
    N/a