Endpoint Protection

 View Only

Move The Database of SEPM From Embedded To Microsoft SQL Server 

Oct 04, 2015 10:20 AM

You can move the database of the SEPM from an embedded one to a Microsoft SQL Server, and here are the detailed steps:

1. Backup the database by running 'Database Backup and Restore' tool from Windows Start:

MoveToSQL_01.png

2. Backup the 'Server Private Key Backup' which locates at the installation folder of SEPM:

MoveToSQL_02.png

3. Here are the two things we backup:

MoveToSQL_03.png

4. Uninstall the SEPM, select delete database during the unistall process, then reboot the system;

5. Re-install the SEPM, after the 'Management Server Configuration Wizard' launched, select 'Custom configuration', and do not select 'Use a recovery file to restore communication with previously deployed clients':

MoveToSQL_04.png

6. Select the database type as 'Microsoft Server Server database':

MoveToSQL_05.png

7. Select 'Create a new database':

MoveToSQL_06.png

8. After the SEPM installed and configured, log into SEPM admin console, select the server name and click 'Manage Server Certificate':

MoveToSQL_07.png

9. Select 'Update the server certificate':

MoveToSQL_08.png

10. Click 'Yes' to confirm the certificate update:

MoveToSQL_09.png

11. Select 'JKS keystore' as the server certificate type:

MoveToSQL_10.png

12. Unzip the recovery_xxxx-xx-xx-xx-xx-xx.zip under the backup folder, open the settings.properties with notepad, copy the value of the keystore.password:

MoveToSQL_11.png

13. Select the JKS keystore file under the backup folder, and paste the password into the 'Keystore password' field and 'Key password' field:

MoveToSQL_12.png

14. Stop these two services: 'Symantec Endpoint Protection Manager' and 'Symantec Endpoint Protection Manager Webserver':

MoveToSQL_13.png

15. Restore the database by running the 'Database Backup and Restore' tool:

MoveToSQL_14.png

16. Restore the database that backup on step 1:

MoveToSQL_15.png

17. After the database restored, the 'Management Server Configuration Wizard' will launch, select 'Reconfigure the management server', do not select 'Use a recovery file to restore communication with previously deployed clients':

MoveToSQL_16.png

18. During the reconfiguration, click 'Yes' to replace the management server name:

MoveToSQL_17.png

19. After the reconfiguration finished, all the client will connect back to the SEPM automatically.

Statistics
0 Favorited
52 Views
0 Files
0 Shares
0 Downloads

Tags and Keywords

Comments

Jul 18, 2018 03:04 AM

Hi,

is the above steps applicable on SEPM 14 RU1 MP2? 

 

Jul 18, 2018 02:45 AM

Dears,

Is there a new procedure to use with SEPM 14 RU1 MP2 or the above steps can be used?

Appreciate your reply.

Regards,

Dec 10, 2017 08:05 AM

SQL Server Express is not supported per the release notes:

https://support.symantec.com/en_US/article.INFO4624.html#SEPM

Dec 10, 2017 07:39 AM

Please respond to this question ; which SQL Server Express compatable for SEPM 14.0.249.0100  (version 14 MP1) ?

Nov 22, 2017 02:15 AM

Will this procedure work on SEP14 as well?

 

Thanks,

Stefan

Feb 25, 2017 12:47 PM

Have you looked in the scm-server-0.log file for errors? What about running the SymDiag tool on it for additional error checking?

Feb 25, 2017 12:32 PM

Please respond to why its doing that. I do not want to go to SQL Server right now and the solution.

Feb 25, 2017 07:00 AM

Sorry for the delayed response. Let me know if still looking for any assistance?

Feb 06, 2017 04:38 PM

I need to find out why the Embeded Database Service stuck in Starting mode. It will not stop, restart or started again after computer restarted. How can it be started again?

Jan 31, 2017 11:45 PM

Yes i want to migrate. Because my customer he want collect log for generate report more than 1 year.

Dec 19, 2016 10:21 AM

Embedded database can support upto 5000 clients. Do you want to migrate them to SQL database?

 

Dec 19, 2016 04:58 AM

This solution  Work for 1500+ Client ?

Oct 07, 2016 07:57 AM

No. Database schema has changed.

Oct 07, 2016 01:44 AM

Hi, Is this applicable on 12.1.6 mp5? We noticed that the db schema for 12.1.6mp5?

Aug 22, 2016 03:17 AM

Small Business Edition supports up to 250 clients with Embedded database only. The Endpoint Protection Small Business Edition 12.1.x product has reached End-of-life and is set to be replaced by the Hosted (or .Cloud) version of the product.

Mar 02, 2016 10:22 AM

Will this work with small business edition?

Oct 06, 2015 03:40 AM

You are a champ , nicely put in . Simple and Precise ofcourse with the screenshots  :)

Related Entries and Links

No Related Resource entered.