How to correct issue where ‘Operating System’ for Windows 2000 servers does not appear properly
This is a recently discovered issue that has already been posted by Michael Michael on his great blog site, and there is an upcoming KB article as well. I’ve assembled step by step instructions for the SQL-challenged such as myself. The SQL tools required are free to download and explained at the bottom of this post. Enjoy!
Problem
Windows 2000 Server and Advanced Server virtual machines display an Operating System property of 'Unknown.' If the Operating System property is set manually, it will revert to 'Unknown' following an automatic SCVMM refresh. There are no errors associated with this change.
Resolution
Follow Michael’s post here, or the step by step instructions below. Same content, more pictures here. ;)
Instructions
1. Close the SCVMM Admin Console
2. Open the MICROSOFT$VMM$ database
![clip_image001[4]](https://msdntnarchive.blob.core.windows.net/media/TNBlogsFS/BlogFileStorage/blogs_technet/jonjor/WindowsLiveWriter/HowtocorrectissuewhereOperatingSystemfor_DF9D/clip_image001%5B4%5D.png "clip_image001[4]")
3. Open the VirtualManagerDB database. Your database has a different name if you changed this during SCVMM install.
![clip_image002[4]](https://msdntnarchive.blob.core.windows.net/media/TNBlogsFS/BlogFileStorage/blogs_technet/jonjor/WindowsLiveWriter/HowtocorrectissuewhereOperatingSystemfor_DF9D/clip_image002%5B4%5D.png "clip_image002[4]")
4. Click ‘New Query’ at the top of the window. Enter the query below as two lines and click ‘Execute’ (or press F5).
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')
5. You should see the results below under ‘Messages’.
(1 row(s) affected)
(1 row(s) affected)
6. Close the SQL Management Studio, answering No or Cancel to any prompts.
7. Restart the VMMAgent and VMMService services.
8. Open the Admin Console and refresh your Hosts. Within 30 minutes any Windows 2000 VMs that have Integration Components (Virtual Guest Services) installed will show the correct Operating System property.
SQL Tools
Use SQL Server Studio Management Express (or SQL) 2005 or 2008. Microsoft SQL Server Management Studio Express can be downloaded free here:
Prerequisites – The SQL Express installer will prompt to install these for you
Note: You must have administrative rights on the computer to install Microsoft SQL Server 2008 Management Studio Express. We recommended that you read the Release Notes and Readme before installing Microsoft SQL Server 2008 Management Studio Express.
Step 1: Download and install Microsoft .Net Framework 3.5 SP1.
Step 2 Download and install Windows Installer 4.5.
Step 3 Download and install Windows PowerShell 1.0.
…