We help IT Professionals succeed at work.

SQL 2008 R2 Trial Version to Full Version

StepOneTL asked
I downloaded and installed SQL 2008 R2 Trial Version and subsequently purchased licensing for the server and the users through Microsoft.  Is there a way to "Activate" SQL 2008 R2 and make it a full version like there was with Windows 2008 R2?  If so, how?
Watch Question

Topic Advisor, Page Editor
Distinguished Expert 2018
Yes you can. Well, there are a couple of potential issues if it has already expired - and in which case the upgrade may not work without uninstalling first then reinstalling (take a backup copy of your databases so you can recover those).

First double check the actual versions : http://msdn.microsoft.com/en-us/library/ms143393.aspx

Then go through the UPGRADE option when instllling the full version : http://blogs.msdn.com/b/wesleyb/archive/2010/05/03/can-i-upgrade-my-sql-server-2008-r2-trial-to-a-full-version.aspx


Thanks Mark,

I was getting an error about the .msi file not being found during install so I uninstalled SQL 2008 R2 Trial and did a clean install of SQL 2008 R2 full version.  It turns out the error was due to some DVD Driver or something because I extracted the iso locally and it worked.  It ended up being a clean install in any case.
Mark WillsTopic Advisor, Page Editor
Distinguished Expert 2018

>> due to some DVD Driver

Ouch, that definitely wasnt one of the first thoughts, but have heard about manual extracts being used :)

Glad to hear you now have it all working.