How to perform an SQL Server Edition Upgrade

re: How to perform an SQL Server Edition Upgrade

Vincent — Tue, 19 Mar 2013 10:51:07 GMT

hello,

Thank you for your procedure which is clear.

I did the update of SQL 2008 R2 SP1 Express Edition with Advanced Services to Standard Edition.

but even after restarting the server, the query "SELECT @ @ VERSION;" tells me that the Express version is still installed.

Can you help me?

please

Vincent

re: How to perform an SQL Server Edition Upgrade

Jacqui — Thu, 15 Mar 2012 10:13:43 GMT

Thank you!!!! for this it was of immense help, especially the part about inserting the CD. I kept on getting the error incorrect product key until I inserted the CD.

re: How to perform an SQL Server Edition Upgrade

Jonas — Tue, 04 Oct 2011 06:58:47 GMT

I have the same question. It appears like I have to do a "manual" upgrade in that case..

re: How to perform an SQL Server Edition Upgrade

Dmitry Baranov — Thu, 27 Jan 2011 11:03:27 GMT

The question is: What if I have license on SQL Server 2008 R2 Standard without product key

(built-in in installation disk), SQL Server 2008 R2 Evaluation installed on server and want

to upgrade edition to SQL Server 2008 R2 Standard. Can I run setup.exe from SQL Server 2008 R2

Standard installation media and launch the “Edition Upgrade” wizard?