Getting the OS name for "Windows 2000" to show up properly in the VMM Administrator Console

if you are managing a Windows 2000 Server Virtual Machine with Hyper-V, you might notice that VMM does not recognize this operating system in the Administrator Console. Even if you manually change the OS name in the Virtual Machine properties, VMM will make it empty on the next refresh of the VM.

To get around this issue and get the proper name to display follow these steps

  1. First close the VMM Administrator Console
  2. Then, stop the VMMService windows service on the VMM server computer
  3. Take a FULL database backup of the VMM database [Just in case; this is a safety net in case something goes wrong]
  4. Now you are ready to edit the database and insert the columns that will allow VMM to recognize the OS name for Win2k.
  5. Install Microsoft SQL Server Management Studio Express on the same computer where the VMM database exists. This is a free download from microsoft and you can search for it on Bing.
  6. Open SQL Management Studio, select the VMM database and run the two SQL insertion statements/scripts below. That should change the VMM knowledge of supported guest operating systems and also add Win2k to the list (for both Server and Advanced Server).
  7. Once the sql script complete, restart the VMMService and open the Administrator Console. Wait for approximately 30 minutes to 1 hour and your VMs will display the proper Win2k operating system in the Administrator Console. Make sure your Virtual Machines are running during this time, otherwise the guest operating system version will not be discovered
  8. Good luck

INSERT INTO tbl_IL_OS
                      (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestId)
VALUES     ('08f954f9-6475-4e07-9e32-4d2ddefc4c54', 'Windows 2000 Advanced Server', 'Windows 2000 Advanced Server', 1, 3, '5.0', 'x86', 0x3f, 'win2000AdvServGuest')

INSERT INTO tbl_IL_OS
                      (OSId, Name, Description, Edition, ProductType, Version, Architecture, OSFlags, VMWareGuestId)
VALUES     ('e85f1375-c69e-4cbd-8249-0e32caa04abb', 'Windows 2000 Server', 'Windows 2000 Server', 0, 3, '5.0', 'x86' , 0x3f, 'win2000ServGuest')