Video Screencast Help
Symantec Appoints Michael A. Brown CEO. Learn more.

Database Migrate from 2005 to 2012

Created: 02 May 2013 | 1 comment

Hi Team ,

Method 1:

As per the below link from chethan suggestions, I have migrated SQL database from 2005 to 2012. 

https://www-secure.symantec.com/connect/forums/migrating-sepm-database-sql-2005-sql-2008#comment-5834701

After following the steps provided by chethan, we have few issues. Below is procedure which I have done.

1. Backup the SEPM server certificates and properties.

2. Backup the SQL database by using SQL Backup.

3. Uninstall SQL 2005 and SEPM. 12.1 RU1 MP1

4. Installed the SQL 2012 and restore the SQL backup and installed the SEPM 12.1 RU2 and 12.1 RU2 MP1 and configure SQL database as existing Database ,at end of the configuration getting message like that the server exist do you want to overwrite click yes and I click yes.

5. After installation, when I login to SEPM console we are getting unexpected Error, and we lost all client groups which we have created in SEPM. (Groups for desktops and servers). I restored server certificates.

6. After some time clients are reporting to Default Group.

7. For unexpected error I checked all the settings as per the below article. All settings correctly configured like OBDC, local admin rights for Domain account which using  for SQL database.

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

Method 2:

1. Backup the SQL database (Full) by using the SQL backup.

2. Uninstalled the SQL 2005

3. Installed the SQL 2012 STD. Restore the SQL back from backup

4. Reconfigured the SEPM. Clients are reporting to SEPM with correct Groups.  But still here also I am getting Unexpected error while login to SEPM.

5. When I tried to login through Web console also same issue.            

6. When I upgrade the SEPM 12.1 RU2 and RU2 MP1 in existing environment, with SQL 2005 SP4 and SEP 12.1 RU1 MP1, I have no issues while logging to SEPM , we have only issues when we migrated to SQL 2012

I have below question can someone help me on this?

  1. Why Clients groups are deleted even if we are using Existing Database, as per Chetan recommended procedure? And why we need to restore server certificates as we are using the same Hostname and Same database.

 

 

 

 

Operating Systems:

Comments 1 CommentJump to latest comment

Mithun Sanghavi's picture

Hello,

I believe you you have the same comment on: 

https://www-secure.symantec.com/connect/forums/need-migrate-symantec-database-sql-2005-2012

To communicate with the clients, the management server uses a server certificate. For the management server to identify and authenticate itself with a server certificate, Symantec Endpoint Protection Manager encrypts the data by default. However, there are situations where you must disable encryption between the server and the client.

You may also want to back up the certificate as a safety precaution. If the management server is damaged or you forget the keystore password, you can easily retrieve the password.

 

Check this Article:

About server certificates

http://www.symantec.com/docs/HOWTO81145

Hope that helps!!

Mithun Sanghavi
Senior Consultant
MIM | MCSA | MCTS | STS | SSE | SSE+ | ITIL v3

Don't forget to mark your thread as 'SOLVED' with the answer that best helped you.