Is it possible to upgrade a WID (windows internal database) 2014 to 2016 and also how to apply security updates.

Question

Is it possible to upgrade a WID (windows internal database) 2014 to 2016 and also how to apply security updates. provide details about 'WID' and also how to install 'WID'

please provide any documents using GUI.

Answer 1

WID 2014 is included in Windows Server 2012 R2, while WID 2016 is included in Windows Server 2016. AFAIK, WID upgrades are tied to Windows Server versions, so you cannot directly upgrade WID 2014 to 2016 without upgrading the Windows Server itself.

1. Check Current WID Version
   • Open PowerShell as Administrator and run:

          Get-WmiObject -Namespace "root\Microsoft\SqlServer\ComputerManagement14" -Class SqlServiceAdvancedProperty | Where-Object {$_.PropertyName -eq "Version"}
     

   • If WID is 2014 (12.x.xxxx), you are on Windows Server 2012 R2.
   • If WID is 2016 (13.x.xxxx), you are on Windows Server 2016.
2. Upgrade Windows Server
   • Since WID is tied to the OS version, upgrade Windows Server 2012 R2 to Windows Server 2016.
   • WID will automatically be upgraded during the process.
   • If WSUS is installed, you may need to reconfigure WSUS after the upgrade.

Security updates for Windows Internal Database are delivered through Windows Update. To manually check for and install updates:

1. Check for WID updates in Windows Update:
   • Open Settings → Update & Security → Windows Update.
   • Click Check for updates.
   • If any WID security updates are available, install them.
2. **Manually install WID security updates **
   • Go to the Microsoft Update Catalog: https://www.catalog.update.microsoft.com
   • Search for Windows Internal Database updates for your server version.
   • Download and install the latest security patches.

To install WID via GUI

1. Open Server Manager
   • Press Win + R, type servermanager.exe, and press Enter.
2. Add the WID Feature
   • Click Manage → Add Roles and Features.
   • Choose Role-based or feature-based installation.
   • Select the local server.
   • In the Features section, scroll down and check Windows Internal Database.
3. Confirm and Install
   • Click Next, then Install.
   • Wait for the installation to complete.
   • Restart the server if prompted.

---

If the above response helps answer your question, remember to "Accept Answer" so that others in the community facing similar issues can easily find the solution. Your contribution is highly appreciated.

hth

Marcin