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.
Best 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.