Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

Need to migrate Symantec Database (SQL) from 2005 to 2012

Created: 22 Apr 2013 | 17 comments

Hi ,

we are planning to migrate teh SQL database from 2005 to 2012.. we have one primary server and one secondary server.

Database is installed on Primary server. No database on Secondary server. Is there any Documents for this?

After SQL migration , did we need to re confiure SQPM sever. are any requirments required for this?

Operating Systems:

Comments 17 CommentsJump to latest comment

.Brian's picture

You can follow this KB article

How to move the Symantec Endpoint Protection Manager SQL database to a new SQL Server

Article:TECH174821  |  Created: 2011-11-18  |  Updated: 2012-01-06  |  Article URL http://www.symantec.com/docs/TECH174821

Good thread about it here:

https://www-secure.symantec.com/connect/forums/ins...

Please click the "Mark as solution" link at bottom left on the post that best answers your question. This will benefit admins looking for a solution to the same problem.

Mithun Sanghavi's picture

Hello,

What version of SEP 12.1 are you running?

Make sure you are running SEP 12.1 RU2 and above.

Check this Article:http://www.symantec.com/docs/TECH200682

The SEP 12.1 RU2 SEPM can use the following releases of Microsoft SQL Server as its datastore:

  • SQL Server 2005, SP4
  • SQL Server 2008
  • SQL Server 2008 R2
  • SQL Server 2012

All versions are supported, except for Compact or Express versions of MS SQL.

Secondly, you may like to check this Article:

Migrating to Microsoft SQL 2008 from a previous version

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

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.

San1985's picture

Hi Mithun,

Currently we are running on SEPM 12.1 RU1 MP1. Database is installed in primary SEPM server.

After reading the articles I undersstand the below procedure.. Please  correct if I am wrong.

1. First we need to take SQL Backup  through SQL

2. Backup the server certificates. (DId we need to back database through SEPM through  backup and restore tool?)

3. Un install the SEPM . and uninstall the SQL 2005 . But some where in the article they have mention that to install the SQL client tools.. why we need to install SQL client tools , when database is  in same server where SEPM is installed.

4. Now Install the SQL server 2012  , restore teh SQL database through SQL and install the SEPM . and restore the server certificates. and select the exsisting Database.

5. Now no need to reconfiure the SEPM sever, because during SEPM installation , all details will be provided like SQL databse path.

6. Currently we have installed SQL 2005 in windows authentication mode. now can we install SQL 2012 in mixed authentication mode..?

please let me know if I miss anything?

W007's picture

hello,

Check chetan comments

https://www-secure.symantec.com/connect/forums/mig...

Look this discussion

https://www-secure.symantec.com/connect/forums/sep...

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

San1985's picture

Hi Manish,

Thanks for the articles.  Bit my question is why we need to install SQL client ? this part confuses me..

Because we have only installed SQL server ?

Rafeeq's picture

If your database is located on a remote server, you must also install SQL Server client components on the computer that runs Symantec Endpoint Protection Manager. if its local not needed

 
San1985's picture

Hi,

I have one more question.

Currenty we have installed SQL 2005 Ent SP3, not we are planning to install SQL 2012 STD version .

Is there any issues  while restoring the SQL database (2005 Ent ) to 2012 STD, is it recommended ? or it supported ?

Not sure whetehr this is roght plcae to ask this question , can any one  clarify my question

.Brian's picture

Per release notes, it is supported:

System Requirements for Symantec Endpoint Protection, Enterprise and Small Business Editions, and Network Access Control 12.1.2

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

So you should be able to do this.

Please click the "Mark as solution" link at bottom left on the post that best answers your question. This will benefit admins looking for a solution to the same problem.

pete_4u2002's picture

on secondary server (load balancing) you need to install the SQL client for 2012.

San1985's picture

 May be My question confuses ..  MY question is

Is SQL 2005 Ent database support on SQL 2012 STD version ?

we are taking backup from SQL 2005 Ent version and restoring on SQL 2012 STD  version.

W007's picture

hello,

You can check this Microsoft Kb

Supported Version and Edition Upgrades

http://msdn.microsoft.com/en-us/library/ms143393.aspx

Upgrade from

Supported upgrade path

SQL Server 2005 SP4 Enterprise

SQL Server 2012 Enterprise

SQL Server 2012 Business Intelligence

SQL Server 2005 SP4 Developer

SQL Server 2012 Developer

SQL Server 2005 SP4 Standard

SQL Server 2012 Enterprise

SQL Server 2012 Business Intelligence

SQL Server 2012 Standard

SQL Server 2005 SP4 Workgroup

SQL Server 2012 Enterprise

SQL Server 2012 Business Intelligence

SQL Server 2012 Standard

SQL Server 2012 Web

SQL Server 2005 SP4 Express,

SQL Server 2005 SP4 Express with Tools, and

SQL Server 2005 SP4 Express with Advanced Services

SQL Server 2012 Enterprise

SQL Server 2012 Business Intelligence

SQL Server 2012 Standard

SQL Server 2012 Web

SQL Server 2012 Express

SQL Server 2008 SP2 Enterprise

SQL Server 2012 Enterprise

SQL Server 2012 Business Intelligence

SQL Server 2008 SP2 Developer

SQL Server 2012 Developer

SQL Server 2008 SP2 Standard

SQL Server 2012 Enterprise

SQL Server 2012 Business Intelligence

SQL Server 2012 Standard

SQL Server 2008 SP2 Web

SQL Server 2012 Enterprise

SQL Server 2012 Business Intelligence

SQL Server 2012 Standard

SQL Server 2012 Web

SQL Server 2008 SP2 Workgroup

SQL Server 2012 Enterprise

SQL Server 2012 Business Intelligence

SQL Server 2012 Standard

SQL Server 2012 Web

SQL Server 2008 SP2 Express,

SQL Server 2008 SP2 Express with Tools, and

SQL Server 2008 SP2 Express with Advanced Services

SQL Server 2012 Enterprise

SQL Server 2012 Business Intelligence

SQL Server 2012 Standard

SQL Server 2012 Web

SQL Server 2012 Express

SQL Server 2008 R2 SP1 Datacenter

SQL Server 2012 Enterprise

SQL Server 2012 Business Intelligence

SQL Server 2008 R2 SP1 Enterprise

SQL Server 2012 Enterprise

SQL Server 2012 Business Intelligence

SQL Server 2008 R2 SP1 Developer

SQL Server 2012 Developer

SQL Server 2008 R2 SP1 Standard

SQL Server 2012 Enterprise

SQL Server 2012 Business Intelligence

SQL Server 2012 Standard

SQL Server 2008 R2 SP1 Web

SQL Server 2012 Enterprise

SQL Server 2012 Business Intelligence

SQL Server 2012 Standard

SQL Server 2012 Web

SQL Server 2008 R2 SP1 Workgroup

SQL Server 2012 Enterprise

SQL Server 2012 Business Intelligence

SQL Server 2012 Standard

SQL Server 2012 Web

SQL Server 2008 R2 SP1 Express,

SQL Server 2008 R2 SP1 Express with Tools, and

SQL Server 2008 R2 SP1 Express with Advanced Services

SQL Server 2012 Enterprise

SQL Server 2012 Business Intelligence

SQL Server 2012 Standard

SQL Server 2012 Web

SQL Server 2012 Express

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

SMLatCST's picture

Is this more a SQL question than a SEP question?

Perhaps the below would help:

http://msdn.microsoft.com/en-us/library/ms177429.aspx

SEPM does support SQL Server 2012

San1985's picture

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.
Mithun Sanghavi's picture

Hello,

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.

San1985's picture

Thanks Mithun for clarification ,Yes same thing I created a new thread, I got error message while posting the comments , thats why I cretaed new thread  ....

.My question is why client groups are deleted, and why Unexpexted error error occur while login to SEPM?

Mithun Sanghavi's picture

Hello,

I would request you to create a case with Symantec Technical Support Team.

You may submit the scm-server-0.log and catalina.out log to the Support Team.

How to create a new case in MySymantec (formerly MySupport)

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

Regional Support Telephone Numbers:

  • United States: 800-342-0652 (407-357-7600 from outside the United States)
  • Australia: 1300 365510 (+61 2 8220 7111 from outside Australia)
  • United Kingdom: +44 (0) 870 606 6000

Additional contact numbers: http://www.symantec.com/business/support/contact_techsupp_static.jsp

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.