SCCM 2007 Migration

We have installed SCCM 2007 installed on windows server 2003.
We have configured 3 sites.

we need to upgrade the hardware and operating system for the SCCM 2007. For this we have purchased new hardware and we want to install SCCM 2007 on windows server 2012.

We found that SCCM 2007 is not supported for the Windows server 2012. it is supported on Windows server 2008 R2 at last. Is that correct?

Also kindly suggest for the latest SQL server version which is supported for SCCM 2007.

We want to migrate SCCM 2007 with SCCM 2007 only. kindly suggest the best practices or the reference links which we can follow for the migration process.
rigelnetAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

David Johnson, CD, MVPOwnerCommented:
2012Sp1 -- be careful with the collation SQL_Latin1_general_CP1_CI_AS  is the only supported one
http://technet.microsoft.com/en-us/library/gg682077.aspx
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
rigelnetAuthor Commented:
Finally we have migrated current sccm 2007 to new hardware with sccm 2007 andwindows server 2008 R2.

We have migrated all site to new sccm 2007 with same version and we found all settings on new server.

but the thing is we can not able to update the collection membership. After the site back up restore when we tried to reset site settings using the sccm setup wizard it gives below error.

"setup has encountered fatal errors: while installating SMS Services"

Also we have verified the event logs and we found two even ID 1020 error and event ID 7000.

I have attached screenshot here.
Kindly suggest.
sccm1.jpg
sccm2.jpg
sccm3.png
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Applications

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.