Migrate From Embedded DB To SQL Server DB
We are currently running SEPM 11.0.5 using the embedded database. We have been having problems with the database not starting and continually shutting down. I have gone thru the repair of SEPM and still have not had any success. We are getting the following errors:
The Symantec Embedded Database service on Local Computer started and then stopped. SOme services stop automatically if they are not in use by other services or programs.
Event ID: 1
Source: ASA 9.0
The description for Event ID 1 from source ASA 9.0 cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.
If the event originated on another computer, the display information had to be saved with the event.
The following information was included with the event:
Could not start server
Running the dbvalidator returns:
2010-02-17 09:47:53.235 INFO: logger initialized ...
2010-02-17 09:47:53.235 INFO: SEPM Server Home:[C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\Tools\..\tomcat]
2010-02-17 09:48:01.768 SEVERE: ERROR: can't init database. exit.
Running dbsrvr9 returns against the sem5.db returns:
Internal database error ***ERROR*** Assertion failed: 201501 (220.127.116.1154)
Page for requested record not a table page or record not present on page--transaction rolled back
This is the second time this has occured. After the first instance, I did a complete reinstall and the issue returned after about a month.
I would like to reinstall using the local SQL Server 2005 database instead of the embedded database (the server is WIndows Server 2008-R2). We have about 30 clients and I would appreciate instruction on how to:
1) Reinstall and use SQL 2005.
2) Reconnect the existing clients without having to do a reinstall on each client.
Thank you in advance for any suggestions or comments.