this is a SEPM 12 installation
a week ago we started getting this error in the Server Application eventlog (win server 2003):
==========================================
Event Type: Error
Event Source: SQLANY 11.0
Event Category: None
Event ID: 1
Date: 04/10/2011
Time: 12:45:38
User: N/A
Computer: BHS-MS-003
Description:
The description for Event ID ( 1 ) in Source ( SQLANY 11.0 ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: SQLANYs_sem5, *** ERROR *** Assertion failed: 100904[sem5] (11.0.1.2472)
Failed to redo a database operation (id=4, page_no=0x6a, offset=0xe83) - Error: Cannot access file 'C:\Program Files\Symantec\Symantec Endpo.
=====================
Event Type: Error
Event Source: SQLANY 11.0
Event Category: None
Event ID: 1
Date: 04/10/2011
Time: 12:45:39
User: N/A
Computer: BHS-MS-003
Description:
The following information is part of the event: SQLANYs_sem5, Internal database error *** ERROR *** Assertion failed: 100904[sem5] (11.0.1.2472)
Failed to redo a database operation (id=4, page_no=0x6a, offset=0xe83) - Error: Cannot access file 'C:\Program Files\Symantec\Symantec Endpo -- transaction rolled back.
=============================
Event Type: Error
Event Source: SQLANY 11.0
Event Category: None
Event ID: 1
Date: 04/10/2011
Time: 12:45:39
User: N/A
Computer: BHS-MS-003
Description:
The following information is part of the event: SQLANYs_sem5, Could not start server.
=================================================
The Endpoint Protection Manager service will start, but after the Embedded Database service fails to start the Endpoint Protection Manager sevrice stops.
I cannot login to the database.
I initially discovered the problem when I tried to login. I couldn't so ended up running resetpass.bat - however this failed becuase a connection to the database could not be made. That's when I dug deeper into event logs.
I have tried to run the rebuild process described here:
http://www.symantec.com/business/support/index?page=content&id=TECH162743
but at Step 6 (running the unload command) I get the error ***** SQL error: Request to start/stop database denied
I suspect this is a password problem for the DBA account. The technician who did the original install assures me that he used the default password (which I take to be "admin") but that doesn't work.
I have no backups of the databse or settings (stupid I know).
what are my options from here please?