Endpoint Protection

 View Only

  • 1.  SQL Service Stops - SEPM

    Posted Apr 20, 2012 11:19 PM

    Hi,

    Iam Using SEPM 12.1 RU1 with SQL Database.

    Now my issue is our SQL service is frequently getting stopped..

    but after we manually started its no problem.

    Why the SQL service stops?



  • 2.  RE: SQL Service Stops - SEPM

    Posted Apr 20, 2012 11:21 PM

    this is known issue resolved in SEP 12.1 RU1

    kindly check this artical.

    http://www.symantec.com/business/support/index?page=content&id=TECH174565



  • 3.  RE: SQL Service Stops - SEPM

    Broadcom Employee
    Posted Apr 21, 2012 01:18 AM

    what is the event id when sql stops?

     



  • 4.  RE: SQL Service Stops - SEPM

    Posted Apr 21, 2012 10:16 AM

    Please, share the fix ID.



  • 5.  RE: SQL Service Stops - SEPM

    Posted Apr 22, 2012 11:23 PM

    Event ID is 4100



  • 6.  RE: SQL Service Stops - SEPM

    Broadcom Employee
    Posted Apr 23, 2012 12:50 AM

    can you copy the full content of the message?

    also can you check scm-server-0.log if the tables are full?



  • 7.  RE: SQL Service Stops - SEPM

    Posted Apr 23, 2012 02:48 AM

    The semsrv service has timed out during a stop request and is being terminated.

    No log full data.

     



  • 8.  RE: SQL Service Stops - SEPM

    Broadcom Employee
    Posted Apr 23, 2012 03:03 AM

    can you pass on the scm-server-0.log immediately after the service is stopped?



  • 9.  RE: SQL Service Stops - SEPM

    Posted Apr 24, 2012 10:50 AM

    Hi,

    if the SQL service is stoppping, it the scm-server-0.log, you will likely see that the SEPM service stopped just because the SQL service stopped first. You may eventually see what the SEPM was doing before SQL service stopped.

    if the SQL service is stopping, you then need to analyze SQL logs, once you know the nature of issue, you may say or not if the cause is down to the SEPM or something else.