May 9, 2012
tom

Can I downgrade SQL Server 2008 R2 Standard To Web Edition?

Question

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.

Asked by GraemeMiller

Answer

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.

Answered by Sašo

Related posts:

  1. Is it possible to downgrade Windows Server 2008 Standard to Web edition remotely?
  2. Can you upgrade SQL Server 2008 SP2 Standard Edition to 2008 R2 Developer Edition?
  3. SQL Server Developer Edition versus SQL Server Standard
  4. SQL Server 2008 Web edition – access from another IIS?
  5. Windows Server 2008 standard edition vs. Windows Server 2008 Enterprise edition

Leave a comment