Video Screencast Help
Scheduled Maintenance: Symantec Connect is scheduled to be down Saturday, April 19 from 10am to 2pm Pacific Standard Time (GMT: 5pm to 9pm) for server migration and upgrades.
Please accept our apologies in advance for any inconvenience this might cause.

SEPM 12 replication with different SQL version

Created: 20 Jun 2013 | 12 comments

will SEPM 12 replication works with different SQL version below:

 

SQL version

10.00.4000

10.50.2500

 

Operating Systems:

Comments 12 CommentsJump to latest comment

SameerU's picture

Hi

Yes as per my knowledge it work as long as the SEPM version is same as that of old

Regards

 

W007's picture

hello,

Will SEPM 12 replication works with different SQL version below:

 Yes it's work without any issue,SEPM replication only required same SEPM version.if you having different sql database version you can replication both sepm withount any problem.

http://www.symantec.com/connect/articles/replication-and-considerations

 

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

pete_4u2002's picture

just make sure the SQL version is supportred for SEPM install.

Replication can between SQL & Embedded database as well.

Rafeeq's picture

Following are supported (12.1 version of SEP)

 

  • SQL Server 2000, SP4 or later
    SQL Server 2005, SP2 or later
    SQL Server 2008, all service packs
    SQL Server 2008 R2, all service packs [SQL Server 2008 R2 SP1 for 12.1 Release Update 1 (RU1)]

 

10.00.4000 is SQL Server 2008 SP2

10.50.2500 is SQL Server 2008 R2 SP1

 

Its supported.

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

Mick2009's picture

"Thumbs up" to the above good advice!

Yes, replication will work if one server is running SQL Server 2008 SP2 and the other is on SQL Server 2008 R2 SP1.  (The important thing is that both SEPMs have the same exact version of SEP running).  Personally, I recommend ensuring that all MS SQL servers are always updated to their latest SP and patch level.  Also ensure that those MS SQL servers have regular backups and maintenence tasks running, and that an admin is checking their logs to ensure that the servers are healthy and performing well. 

That is all just MS SQL best practice.  If the MS SQL servers crash, run into difficulty or are compromised, it can have a serious effect on the SEPMs!  A ittle upkeep and prevention is far better than a crisis.  &: )

With thanks and best regards,

Mick

With thanks and best regards,

Mick

Chetan Savade's picture

Hi,

Thank you for posting in Symantec community.

I would be glad to answer your question.

Symantec won't support if there is a difference in SEPM manager versions.

Refer the below article:

Does Symantec Endpoint Protection Manager support replication between sites running different versions?

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

Replication should work between SQL server 2008 SP2 & SQL server 2008 R2 SP1.

 

Chetan Savade
Technical Support Engineer, Endpoint Security
Enterprise Technical Support
CCNA | CCNP | MCSE | SCTS |

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

frieda's picture

ok. the sql port different will cause any issue then?

 

SQL Port number

1433

56552

 

pete_4u2002's picture

no , it does not cause any issue is port is different.

As stated earlier by others the SEPM has to be on same version.

Rafeeq's picture

port has nothing to do with version, it will do fine

A. Wesker's picture

Hi,

 

All you should ensure is to use the SQL version supported depending the version of SEP you'd like to install.

Secondly, ensure to use an SQL Edition supported. At least Standard or Enterprise Edition cause if you're tempted to get a free version like SQL Express. This version is extremely limited and propose only file group limitation of 10Gb each which is clearly not enough for a decent SEPM Database and big site. You'll reach just by keeping few Live Update contents (5-6ish). And it's not a supported edition for SEP anyway.

Thumbs up for all the previous advices provided !

 

Kind Regards,

A. Wesker