I have to downgrade a SQL Server running SQL Server 2008 R2 Standard Edition SP1 to 2008 R2 Web Edition SP1.
I discovered this question on Server Fault:
Which links to a similar scenario:
This server doesn't have Analysis Services installed and I tried to run the Edition "Upgrade" tool and got this failure:
I checked the detailed report and all that it says is:
Rule Name: EditionUpgradeMatrixCheck
Rule Description: Checks whether the selected instance of SQL Server meets upgrade matrix requirements.
Message/Corrective Action: The selected SQL Server instance does not meet upgrade matrix requirements.
Strangely the Edition Downgrade rule has passed.
I ran this from the SQL 2008 R2 Web Edition DVD.
Can anyone guide me through downgrading this SQL server to Web Edition, I am now at a loss.