Upgrading from SQL Server 2008 R2 Express to SQL Server 2008 R2 Enterprise

sql-server windows sql-server-2008-r2 upgrade sql-server-2008r2-express
raladin picture raladin · Jul 28, 2010 · Viewed 33.1k times · Source

When I tried upgrading from SQL Server 2008 R2 Express to SQL Server 2008 R2 Enterprise, it passed all tests and then it failed at step "Select features", saying the following error:

There are no features selected for upgrade.

And a window error message:

There are validation errors on this page. Click ok to close this dialog box. Review errors at the button of the setup page, then provide valid parameters or click help for more information.

Is it possible to proceed or do I need to backup, uninstall Express and then install fresh Enterprise edition?

Answer

Prof Von Lemongargle picture Prof Von Lemongargle · Jun 13, 2011

You can run Setup then select Maintenance and Edition Upgrade from that page. From there it seems to be pretty smooth.

Related questions

Can't connect to SQL 2012 remotely by IP and named instance

First off, I already know that Windows Firewall is blocking my connection -- I just don't know what to do about it. When I turn WF all the way off, my remote connection works. I already have a Rule to …

Read More
Access denied for enabled xp_cmdshell for the admin user

I'm using xp_cmdshell within a database trigger to launch a exe file. xp_cmdshell is enabled(it can execute simple cmd command like 'echo'). But when I try to launch the exe through xp_cmdshell, the access is denied. …

Read More
exception has been thrown by a target of invocation in Visual Studio 2013

Today when I opened Visual Studio 2013 Professional Edition, I got the error exception has been thrown by a target of invocation. Also I tried to open ILSpy to debug a dll, but it crashed. I think that it might be …

Read More