I was attempting to upgrade SQL Server 2008 R2 Standard Edition to SQL Server 2008 R2 Enterprise Edition on a development VM. When I got to the "Select Instance" to upgrade page, the MSSQLSERVER instance (i.e., the standard instance I want to upgrade) was not available as an option; only SQLEXPRESS was an option (please see the attached screenshot).
A colleague who did the same process thought this was weird because he WAS able to see MSSQLSERVER as an instance; he chose that, and upgraded it successfully. I went ahead and chose SQLEXPRESS because I thought, well, if that's my only option, I guess I'll go ahead. But after the upgrade, which seemingly was successful, when I run management studio and check the version using T-SQL commands, it tells me it's still standard edition.
Now I'm sort of hosed, because I've got SharePoint running on the VM etc, and I'm afraid if I uninstall everything and start fresh to try and install Enterprise edition, I'll screw up my SharePoint installation etc. I'm backing up my VM as I type this just in case. But, any advice, kind people? Why couldn't the upgrade wizard see that instance? (I tried stopping the service for that instance but the wizard still didn't give that as an option, and now I can't upgrade anything). My next plan is to try and reinstall, but I fear I've may be stuck in "S-Q-L HELL". Thanks, -D