Convert Windows Server 2016 from Eval to Standard or Datacenter

It’s finally possible to convert an evaluation version of Windows Server 2016 to a full Datacenter or Standard Edition.
Apparently it only works for the full GUI version of Windows 2016 🙁
Use the generally available GVLK keys from here : https://technet.microsoft.com/en-us/library/jj612867(v=ws.11).aspx

Datacenter : DISM /online /Set-Edition:ServerDatacenter /ProductKey:CB7KF-BWN84-R7R2Y-793K2-8XDDG /AcceptEula
Standard : DISM /online /Set-Edition:Serverstandard /ProductKey:WC2BQ-8NRM3-FDDYY-2BFGV-KHKQY /AcceptEula

Change Hostnames to UPPER case in SCVMM

Sometimes, when adding new hosts to SCVMM, for unknown reasons, they end up being a mix of upper and lower case.
Theres a couple of descriptions around, about how to fix it with SQL scripts. It seems they only change the names in tbl_ADHC_Hosts table, not those in tbl_ADHC_AgentServer.
This code changes it for both. If you want it to change them all to lower, replace “UPPER” with “LOWER” 😉
Make sure you take a backup of VirtualManagerDB first.
Restart SCVMMService afterwards (A refresh in the console should be enough).


SELECT [ComputerName], UPPER(LEFT([ComputerName], CHARINDEX('.', [ComputerName], 1) -1)) + 
RIGHT([ComputerName], LEN([ComputerName]) - CHARINDEX('.', [ComputerName], 1) + 1) 
FROM [VirtualManagerDB].[dbo].[tbl_ADHC_Host]

SELECT [ComputerName], UPPER(LEFT([ComputerName], CHARINDEX('.', [ComputerName], 1) -1)) + 
RIGHT([ComputerName], LEN([ComputerName]) - CHARINDEX('.', [ComputerName], 1) + 1) 
FROM [VirtualManagerDB].[dbo].[tbl_ADHC_AgentServer]

UPDATE [VirtualManagerDB].[dbo].[tbl_ADHC_Host] 
SET [ComputerName] = UPPER(LEFT([ComputerName], CHARINDEX('.', [ComputerName], 1) -1)) + 
RIGHT([ComputerName], LEN([ComputerName]) - CHARINDEX('.', [ComputerName], 1) + 1)

UPDATE [VirtualManagerDB].[dbo].[tbl_ADHC_AgentServer] 
SET [ComputerName] = UPPER(LEFT([ComputerName], CHARINDEX('.', [ComputerName], 1) -1)) + 
RIGHT([ComputerName], LEN([ComputerName]) - CHARINDEX('.', [ComputerName], 1) + 1)

Result :

vmmuppercase