Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

We are running a SQL Server 2008 R2 Standard Evaluation version. The client has decided they don't want to pay for full SQL Server standard and feel the Web edition is suitable. Can I downgrade SQL Server 2008 R2 Standard Evaluation to Web Edition?

Obviously I need to put a licence on it. Can I just put the Web edition licence on it and it will become a Web Edition server or does it require a re-install.

share|improve this question
What did Microsoft say when you asked them? – John Gardeniers May 9 '12 at 8:42
possible duplicate of Can you help me with my software licensing issue? – John Gardeniers May 9 '12 at 8:44
I don't deal with that part of the business etc. (and it would take me an age to get a response) I just needed to know from a technical point and just hoped someone may have actually done it. – GraemeMiller May 9 '12 at 8:46
up vote 1 down vote accepted

This should answer your question:

MSDN: Downgrading from SQL Server 2008 R2 Enterprise Edition (trial) to R2 Web Edition (licensed)

You only need to uninstall Analysis service before running edition upgrade. And, of course, make a just-in-case database backup.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.