Sql-server – Upgrading SQL Server (2014) Express to Standard

licensingmicrosoftsql serversql-server-2014

I have a server running SQL Server 2014 Express Edition that is fast approaching the 10GB limit for a database.

I've now purchased SQL Server 2014 Standard and wish to use it. SQL Server is no longer available by boxed copy, so, I purchased it on Open with the relevant CALs.

When I go to VLSC, I am only given the option to download the ISO files to perform a fresh install – I have done this countless times on fresh installs without issue.

However, when you go in to the setup for Express, you do have the option to change versions if you have a serial key:

enter image description here

I have tried contacting Microsoft without any luck what so ever.

I was wondering if anyone can help as I would obviously prefer to input a small key and change the license rather than having to reinstall over the top.

Best Answer

In the \x64 folder there is a file called DefaultSetup.ini where the PID will be. Once you copy the PID from there, run the setup and choose edition upgrade as you've already shown and input the PID copied from the file.

Related Topic