Moving SQL 2008 R2 to 2012 on same server for SCCM 2012

As the title states I need to move my existing database from SQL 2008 R2 to SQL 2012 due to a licensing issue. The database is running SCCM 2012 SP1. What happened is that I installed the standard trial version of 2008 R2 with 180 day expiration, but as it turned out I should have installed the enterprise version. I'm flat out not able to purchase a serial number to upgrade the trial to full version to due the Microsoft agreement with my institution.

Very straight forward setup. One server with SCCM 2012 (SP1) currently using SQL 2008 R2 for the backend on the same server. I need to uninstall SQL 2008 R2 and do a clean install of SQL 2012. I absolutely do not want to start over with my SCCM 2012 installation as everything is working as it should. I need to migrate over the existing database to a new install of 2012.

What would be the recommended course of action be?

I've never done much with SQL, but I would think it would be reasonable to assume I would export the existing database, note all of the users accounts the SCCM uses, import the database to server SQL 2012 server and make sure all the user accounts are the same. Anything you think SCCM with give me problems with doing this?
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.

Aneesh RetnakaranDatabase AdministratorCommented:
You can take a full backup of your databases and go with an in place database upgrade.
David ToddSenior DBACommented:

To script out the accounts (and encrypted password) look up sp_help_revlogin. Its a free script from MS.

Do note that the while this enables you to quick get a script to recreate the accounts, it doesn't give their server roles.

There is an upgrade adviser, that can check procedures and objects.

Should be able to restore a user database from 2008 in 2012.


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
futureman0Author Commented:
So while trying to do a in place upgrade from 2008 R2 to 2012 I got the following error:

Checks whether the specified feature meets SQL Server 2012 upgrade requirements.

The specified edition upgrade is not supported. For information about supported upgrade paths, see the SQL Server 2012 version and edition upgrade in Books Online.

The instance of SQL i'm trying to update is 10.52.4000 running as an evaluation. For whatever reason I have also SQL 2012 Express instance ADK still installed as well. Not really sure what 2012 Express is doing there, and I can't seem to uninstall it.

Any idea what is going to prevent the upgrade? Perhaps going from 2008R2 Evaluation to 2012 SP1 Enterprise isn't allowed?

Any ideas what is going on?
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 SQL Server 2008

From novice to tech pro — start learning today.