WSUS on the fritz again

[bswhipp]

Not sure if this is the correct place but WSUS has stopped working. All clients stuck as 0% download. No real errors in the WSUS log. The files are downloading correct from Microsoft, I can download the iuident and wuident.cab files. No errors in the event viewer. but when you look a the failed link in the report it shows (Unable to Find Resource ReportingEvent.Client.167;. Removed and readded the Content virtual directory to IIS. Can't see to get it working again. Any help would be much appreciated. Thanks

 

[WindowsForum AI]

Ah, the infamous 0x800f081f error! This indicates that DISM couldn't locate the required files to repair the corrupted component store. This often happens in Server environments if the files can't be retrieved from Windows Update (e.g., WSUS restrictions, network issues, or missing source files on disk). No worries—we can handle this.
Here’s what to do:

---

Step 1: Use the Source Option with DISM​

We’ll point DISM to a source file to repair the component store. You’ll need access to a Windows Server 2022 installation ISO (matching your version 21H2, Build 20348.272) or install.wim/ESD from a trusted source.

Steps:​

1. Mount the Windows Server ISO:
   • Insert or mount the ISO on the server.
   • Note the drive letter assigned (e.g., D:).
2. Locate the install.wim File:
   • Navigate to the Sources folder on the mounted ISO:
     

      D:\Sources\install.wim

   • Alternatively, if the file is install.esd, this can also work (slightly different syntax—details below).
3. Run DISM with the Source Option:
   Use the path to install.wim as your source:
   

   bash dism /online /cleanup-image /restorehealth /source:WIM:D:\sources\install.wim:1 /limitaccess

   • Replace D: with your ISO’s drive letter.
   • Note the :1 specifies the correct image index for the Standard Edition. If unsure, identify the exact index in Step 4 below.
4. [Optional] List Available Image Indices:
   If you’re unsure of the correct index, list the available editions in the WIM/ESD file:
   

   bash dism /Get-WimInfo /WimFile:D:\sources\install.wim

   • Look for Windows Server 2022 Standard to find the right index number.

If using install.esd:​

If your source file is install.esd rather than install.wim, use:

bash dism /online /cleanup-image /restorehealth /source:ESD:D:\sources\install.esd:1 /limitaccess

1. Retry After Repair:
   Once DISM completes successfully, retry installing KB5046616.

---

Step 2: Ensure Component Store Uses Microsoft Update​

Sometimes WSUS or restricted network policies block DISM from downloading required files. Let’s ensure DISM has access to Microsoft’s online repositories.

1. Temporarily point your system away from WSUS (if applicable):
   • Open Group Policy Editor (gpedit.msc).
   • Navigate to:
     

      Computer Configuration -> Administrative Templates -> Windows Components -> Windows Update

   • Disable "Specify intranet Microsoft update service location".
2. Run gpupdate /force to apply changes.
3. Retry the original DISM command (without /source) to see if it can now pull files from Microsoft:
   

   bash dism /online /cleanup-image /restorehealth

---

Step 3: Check the DISM Log​

If the error persists, check C:\WINDOWS\Logs\DISM\dism.log for clues on:

• What files are missing.
• Whether DISM is looking at the correct paths.

Feel free to share key portions of the log or upload it, and I can analyze it for a more targeted fix.

---

Step 4: As a Last Resort, Repair via In-Place Upgrade​

If nothing else works (and errors persist), you can repair the component store via an in-place upgrade repair:

1. Mount the Windows Server 2022 ISO.
2. Run setup.exe from the mounted ISO.
3. Select Upgrade and ensure you keep files and apps intact.

---

Summary​

• Use install.wim (or install.esd) from an ISO matching your build as the source in DISM.
• Retry pointing systems to Microsoft Update if you suspect WSUS/network restrictions.
• Check the DISM logs if errors still occur.

Let me know how that works out! If you need help with building the correct syntax or identifying image indices, I'm here for that too!

 

[bswhipp]

Servicing Stack Update for 21H2 20348 came back with no results

 

[WindowsForum AI]

It seems like finding the standalone Servicing Stack Update (SSU) for 21H2 Build 20348.x directly via the Microsoft Update Catalog has hit a dead end. This likely means the SSU for 20348.x is rolled into the cumulative updates, and there isn’t a separate download for it anymore. No problem—here's how you can proceed:

---

Step 1: Ensure You’re Fetching Correct Files for Repairs​

To resolve the missing servicing stack issue and proceed with the cumulative update installation, let’s repair the system using a matching Windows Server 2022 ISO (Build 20348.272 or higher).

Getting the Correct ISO:​

• Obtain the ISO matching your build:
• Log into your Microsoft Volume Licensing Service Center (VLSC) or contact your licensing provider to obtain the correct ISO file for Windows Server 2022.
• Alternatively, https://www.microsoft.com/en-us/evalcenter/ offers Windows Server 2022 ISOs for evaluation. Ensure it matches build 20348.x.
• Once the ISO is downloaded, continue with DISM repairs as outlined in https://windowsforum.com/posts/894305.

---

Step 2: Use Online Sources for Repair​

Let’s try connecting DISM directly to Microsoft Update to bypass the need for matching ISO components.

• Run the DISM repair command with online sources:
  

  bash dism /online /cleanup-image /restorehealth /source:MicrosoftUpdate

• This ensures DISM pulls necessary files directly from Microsoft.
• If Microsoft Update access is blocked, disable WSUS temporarily:
• Go into Group Policy:
  

   Computer Configuration -> Administrative Templates -> Windows Components -> Windows Update

• Disable (or clear) the "Specify intranet Microsoft update service location" policy.
• Run:
  

  bash gpupdate /force

• Retry the repair.

---

Step 3: Manually Reinstall Relevant Updates (Latest Cumulative Includes SSU)​

If DISM repairs don’t work, you can manually attempt to install the full cumulative update again, as these usually include the necessary SSU.

Retry KB5046616​

• Ensure you have the correct KB for cumulative update KB5046616.
• Download it directly from the https://www.catalog.update.microsoft.com/:
• Search: KB5046616 for Server 2022 x64.
• Verify the exact build (should already match 20348.x).
• Attempt to install it manually:
  

  bash wusa \kb5046616-x64.msu

• If WUSA (Windows Update Standalone Installer) fails, switch to:
  

  bash dism /online /add-package /packagepath:\kb5046616-x64.msu

---

Step 4: Final Option—In-Place Upgrade Repair​

If the SSU cannot install and servicing stack issues persist, an in-place upgrade repair might be the best course. This overwrites update-related files and reinstalls components while keeping your applications and settings intact.

Steps:​

• Mount a Windows Server 2022 installation ISO with 20348.x or higher.
• Run setup.exe from the mounted ISO.
• Choose Upgrade this PC and ensure you select Keep Files and Programs.

This effectively resets the servicing environment and matches files to your Windows version, resolving issues with DISM or updates.

---

Summary​

• Download the correct Windows 2022 ISO (20348.x) and attempt to repair via DISM.
• Temporarily switch to Microsoft Update if WSUS policies or restrictions are in the way.
• If SSU and servicing stack issues persist, perform an in-place repair upgrade.
  Let me know if you need help finding the matching ISO or running through these steps!

 

[bswhipp]

Can you locate the iso for me?

 

[WindowsForum AI]

Unfortunately, I am unable to directly download or locate an ISO for you due to system restrictions, but here's a clear guide for you to obtain the proper Windows Server 2022 ISO (21H2, Build 20348.x) that matches your configuration.

---

Option 1: Microsoft Volume Licensing Service Center (VLSC)​

• Log into the https://www.microsoft.com/Licensing/servicecenter if you have volume licensing with Microsoft.
• Search for Windows Server 2022 Download.
• Ensure the build is 20348.x (21H2) corresponding to your version:
• Most builds available through VLSC will align with the latest LTSC (Long-Term Servicing Channel) releases for Server 2022.

---

Option 2: Microsoft Evaluation Center​

If you don’t currently have access to VLSC, the Microsoft Evaluation Center provides an official and trustworthy way to download evaluation versions of Windows Server 2022.

• Visit: https://www.microsoft.com/en-us/evalcenter/evaluate-windows-server-2022.
• Click Download the ISO.
• Fill in the form to activate the download.
• Once downloaded, confirm that the build matches 20348.x by mounting the ISO and examining file properties or running the following:
  

  bash dism /Get-WimInfo /WimFile:\sources\install.wim

  Look for the ImageVersion or DisplayVersion corresponding to 21H2 Windows Server 2022.

---

Option 3: Azure Marketplace​

If you use Azure for virtualized environments or testing:

• Access the Azure Portal.
• Search for Windows Server 2022 in your virtual machine image gallery.
• Deploy a Windows Server 2022 VM and use its deployed resources for testing or repairing your local system (e.g., downloading the ISO or performing a network-based repair).

---

Option 4: MSDN / Visual Studio Subscription​

If you have an MSDN account with a Visual Studio subscription:

• Log into your https://my.visualstudio.com/.
• Look for Windows Server 2022 ISO within the Software section.

---

ISO Matching Your Build​

Before downloading, ensure:

• It is Windows Server 2022 (21H2).
• The build number is 20348.x or later—this is critical for compatibility with your current installation.
  Once you’ve obtained the ISO, follow the previous instructions to:
• Mount the ISO.
• Use DISM or an in-place upgrade for repair.
  

  ---

  If you encounter any issues navigating these resources or verifying the ISO, let me know, and I’ll guide you further to ensure you're on the right track!

 

[WindowsForum AI]

Here are some reliable options for downloading the Windows Server 2022 (21H2) ISO corresponding to build 20348.x. Please ensure that you double-check the source to guarantee an authentic and untampered ISO:

---

Official Microsoft Sources:​

• Microsoft Evaluation Center
• https://www.microsoft.com/en-us/evalcenter/evaluate-windows-server-2022
• This is the official Microsoft portal to download evaluation versions of Windows Server 2022 that match your version (build 20348.x). You can later insert your license to activate it fully.

---

Community Archive (Use with Caution):​

• Internet Archive (Archive.org):
• https://archive.org/details/windows-server-2022-ltsc-21-h-2-workstation-build-20348.1006-x-64
• This includes specific builds but should be verified thoroughly after downloading.

Alternatively:

• https://archive.org/details/20348.169.210806-2348.fe-release-svc-refresh-server-eval-x-64-fre-en-us_202112.

Note: Be cautious about using non-Microsoft sources. Validate the image (checksum/hash) to ensure authenticity.

---

Other Methods​

• Azure Virtual Machine:
  If you're using Azure, https://techcommunity.microsoft.com/t5/windows-server-insiders/windows-server-2022-version-21h2-os-build-20348-169/td-p/3042412 and extract or work with the ISO from the base image.

---

When you download the ISO and need assistance repairing your server or mounting it for DISM purposes, just let me know, and I can guide you through!

 

[bswhipp]

There are no real versions to download. I am downloading 2 now the files names are
SW_DVD9_Win_Server_STD_CORE_2022__64Bit_English_DC_STD_MLF_X22-74290.ISO and
SW_DVD9_Win_Server_STD_CORE_2022_2108.39_64Bit_English_DC_STD_MLF_X23-89848.ISO

 

[WindowsForum AI]

Great find on the ISOs! Both of these file names look official, and they appear to be from Microsoft Volume Licensing. Let me break them down for you and help choose the correct one:

---

File Details:​

1. SW_DVD9_Win_Server_STD_CORE_2022__64Bit_English_DC_STD_MLF_X22-74290.ISO:
   • This is likely the base release (RTM) version of Windows Server 2022.
   • It may correspond to a pre-Latest Updates build (20348.1 or slightly later), but you'll still be able to patch after using it.
2. SW_DVD9_Win_Server_STD_CORE_2022_2108.39_64Bit_English_DC_STD_MLF_X23-89848.ISO:
   • The naming indicates this is a refresh version of Windows Server 2022, likely including updates from August 2021 (2108).
   • Better starting point as it may already come with newer build increments (closer to 20348.272+) right out of the ISO.

---

Recommended Choice:​

• Use the second ISO (2108.39)—This version is more recent and will reduce post-installation patching.
• If for any reason your initial repairs with the 2108.39 edition do not work, you can fall back to the base image X22-74290.

---

Steps After the Download:​

1. Verify the ISO Hash/Signature:
   • Check the authenticity of the files (if downloaded from a volume/licensing portal, you can skip this step with more confidence).
   • Tools like PowerShell or CertUtil can compute the SHA1/MD5 hash:
     

     bash certutil -hashfile SHA1

     Cross-check the hash with Microsoft-provided values (if available).
   • Mount the ISO:
     • Mount the ISO using built-in Windows tools:
       • Right-click the file > Mount (note the drive letter, e.g., D:).
   • Run DISM with the ISO:
     • Use install.wim or install.esd from the ISO's Sources directory as your /source for DISM repairs:
       

       bash dism /online /cleanup-image /restorehealth /source:WIM:D:\sources\install.wim:1 /limitaccess

     • If install.wim is not available, confirm install.esd exists and use that syntax:
       

       bash dism /online /cleanup-image /restorehealth /source:ESD:D:\sources\install.esd:1 /limitaccess

   • Retry Installing KB5046616:
     • After repairing the component store, proceed to reinstall KB5046616 using the manual method (wusa.exe or DISM).

---

Let Me Know:​

Once downloaded, let me know which ISO was selected and how the DISM repair works out. If DISM still gives errors or needs different parameters, you can share more details, and I’ll dig deeper!

 

[bswhipp]

Uh oh. Critical Error. Critical Service Failed. Need to restore from backup again.

 

[WindowsForum AI]

Oh no, that's a frustrating turn of events! It looks like something in the process (likely during the DISM repair or installation attempt) caused a critical issue. Restoring from backup is a solid move here—it's always better to return to a safe state rather than continue battling an escalating problem.
Once the system is back up and restored, let’s take a fresh and measured approach. Here’s how we can refine the process to minimize risks when trying the repair again:

---

Post-Restore Strategy​

1. Step One: Baseline Testing
   • Ensure the restored system is stable:
     • Check for Event Viewer Logs for recurring errors.
     • Confirm basic functionality of critical services before proceeding again (in case we missed a warning sign previously).
2. Step Two: Validate Repair Resources (ISO)
   • After restoration, let’s double-check the ISO you’re using:
     • Mount it, and list available images with DISM:
       

       bash dism /get-wiminfo /wimfile:D:\sources\install.wim

       If there’s no install.wim (only install.esd), confirm whether the ISO truly matches your build.
   • Cross-reference ISOs carefully—one common issue occurs when the repair source doesn't exactly match your OS version/build.
3. Step Three: Space and Permissions Check
   • Ensure your Windows server has enough free space on the C: drive before trying DISM again (say, 10+ GB just to be safe).
   • Run sfc /scannow before retrying DISM to spot any integrity issues DISM could exacerbate.
4. Step Four: Controlled Repair
   • When ready, reattempt:
     

     bash dism /online /cleanup-image /restorehealth /source:WIM:\install.wim:1 /limitaccess

     Or try using online sources (/source:MicrosoftUpdate after confirming direct access).
     • Keep log files handy in case of repeat failures:
       • DISM Log: C:\Windows\Logs\DISM\dism.log
       • CBS Log: C:\Windows\Logs\CBS\CBS.log
   • Step Five: Alternative Workaround
     • If repairs are still volatile, we can plan for an in-place upgrade repair. This is more stable than live DISM fixes because the setup performs better dependency checks.

---

Things to Look Out For​

• See if any third-party services were introducing instability during repairs (e.g., antivirus software, WSUS corruption influencing the process).
• Let’s be cautious with when and how the ISO sources are used to ensure no mismatches.

Once your backup is restored, let me know where we left off or what stands out from logs, and we’ll formulate a no-surprises recovery. WSUS has taken enough of your time; let’s beat it this time.

 

[bswhipp]

We will pick this back up tomorrow

 

[WindowsForum AI]

Understood! Take the evening to recharge—WSUS and its antics can certainly test anyone’s patience. We’ll hit the ground running tomorrow and get this sorted for good. Let me know when you're ready to dive back in, and I’ll be here to help! Enjoy the rest of your day.

 

[bswhipp]

OK upon restore, I was able to get the kb installed. Now need to update WSUS version?

 

[WindowsForum AI]

Excellent progress! Getting KB5046616 installed was a big win—now you're on more stable ground. Updating WSUS to match your needs is the next logical step, especially if you still have mismatched schema versions or you're using an older WSUS version.
Let's walk through updating WSUS:

---

Step 1: Verify Current WSUS Version​

Before updating, let's confirm your WSUS version to ensure we're addressing the right compatibility.

1. Run this command in PowerShell (Admin):
   

   powershell Get-ItemProperty "HKLM:\Software\Microsoft\Update Services\Server\Setup" | Select-Object Version

2. This will display your current WSUS version. If it's 5.x, you're running an older WSUS version that might require updates to handle modern updates and schema versions.
   Common versions:
   • 5.0.x.x = WSUS on Server 2016
   • 10.0.x.x = WSUS on Server 2019/2022 (current, modern schema)

---

Step 2: Update WSUS Using the Latest Cumulative Update​

For Windows Server 2022, any necessary WSUS updates will come rolled into the latest cumulative updates (which you've already applied through KB5046616). This means your WSUS components may already be updated, so you should:

1. Run the WSUS Post-Install Command:
   

   bash wsusutil.exe postinstall

   This updates the WSUS configuration files and prepares it to run against any new updates.

---

Step 3: Check the Database Schema​

If the schema version mismatch error persists, verify and update the WSUS database schema:

1. Locate Current Schema Version:
   Connect to your SUSDB database (via SQL Server Management Studio [SSMS] or SQLCMD) and run:
   

   sql USE SUSDB; SELECT * FROM tbSchemaVersion;

   • Match the SchemaVersion against your WSUS server version. If WSUS version or patches are too outdated compared to the schema version, you may still need updates.
2. Manually Apply Schema Updates (if needed):
   Run this in cmd with admin privileges:
   

   bash wsusutil.exe postinstall

---

Step 4: Reindex SUSDB​

To ensure optimal performance with the updated WSUS version, cleanup and reindex the database:

1. Connect to SUSDB and run:
   

   sql USE SUSDB; EXEC spReIndexAllIndexes;

2. If spReIndexAllIndexes is missing, manually rebuild the indexes:
   

   sql USE SUSDB; ALTER INDEX ALL ON [tablename] REBUILD;

---

Step 5: Verify WSUS Works​

1. Check the WSUS Console:
   • Open the WSUS Management Console and confirm it connects successfully, loads properly, and synchronizes updates.
2. Test Client Synchronization:
   • Force a client PC to sync with WSUS:
     

     bash wuauclt.exe /detectnow /reportnow

   • Verify the client appears in the WSUS console as reporting correctly.

---

Optional: Add HTTPS Support (Security Best Practice)​

If you're not already using SSL/HTTPS for WSUS, now is a great time to configure it. Secure communication ensures update data isn’t tampered with in transit:

1. Bind a valid SSL/TLS certificate to WSUS in IIS.
2. Update WSUS group policies to use https://:8531.

---

Once these steps are done, let me know if everything aligns or if you see any lingering issues—there’s no stopping now!

 

[bswhipp]

Back to this
Post install is starting
Fatal Error: Since the SQL instance name does not already exist in the registry and
the WID role service is not installed, the instance name must be specified on
the command line.

 

[WindowsForum AI]

Ah, we're back to the "WID role service not installed" error during the wsusutil postinstall command. This suggests that either the Windows Internal Database (WID) role is still missing or improperly configured, or that WSUS isn't set up correctly to use the database.
Here’s a focused plan to resolve this issue once and for all:

---

Step 1: Verify the WID Role Is Properly Installed​

The issue often arises because Windows Internal Database (WID) isn’t installed, or it's been partially removed.

Check the WID Role Installation:​

1. Open Server Manager > Roles and Features.
2. Under Features, confirm that the Windows Internal Database (WID) role is installed.
   • If it isn’t, install it:
     • Run in PowerShell:
       

       bash Install-WindowsFeature -Name Windows-Internal-Database

     • Reboot if prompted.
3. After installation, verify the service is running in Services.msc:
   • Look for Windows Internal Database (MICROSOFT##SSEE).
   • If it isn’t running, start the service and set it to Automatic.

---

Step 2: Verify SUSDB Instance in SQL​

WSUS requires the SUSDB database to already exist on the WID instance or the SQL server it's attempting to connect to.

Check if SUSDB Exists:​

1. Use SQLCMD or SSMS to connect to the WID instance:
   

   bash np:\\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query

2. Run the query:
   

   sql SELECT name FROM sys.databases;

   • Look for SUSDB in the list.
   • If SUSDB is missing, it must be recreated (see Step 4).

---

Step 3: Run wsusutil with SQL Instance Name​

If WID is installed but not detected by WSUS, you need to explicitly point wsusutil.exe postinstall to the WID SQL instance.

Run the Command:​

1. Add the SQL instance name to the command:
   

   bash wsusutil.exe postinstall SQL_INSTANCE_NAME="MSSQL$MICROSOFT##SSEE"

   If WID works correctly, this will connect WSUS to the database and complete the configuration.

---

Step 4: Create or Reinitialize SUSDB (If It’s Missing or Corrupted)​

If the database doesn't exist (or is damaged):

1. Use wsusutil to reset the database:
   

   bash wsusutil.exe postinstall CONTENT_DIR="D:\WSUS"

2. If it still fails, manually drop and recreate the database:
   • Connect with SQL Management Studio:
     

     sql DROP DATABASE SUSDB;

   • Rerun:
     

     bash wsusutil.exe postinstall CONTENT_DIR="D:\WSUS"

---

Step 5: Consider Full SQL Installation​

If WID refuses to work or you're considering a more scalable setup, you can configure WSUS to use a full SQL Server instance instead of WID.

Install SQL Server Express:​

1. Download and install SQL Server Express 2019/2022.
2. Create a blank database named SUSDB.
3. Run the wsusutil command with the SQL instance name:
   

   bash wsusutil.exe postinstall SQL_INSTANCE_NAME="YourServerName\SQLExpress" CONTENT_DIR="D:\WSUS"

---

Step 6: Verify Logs and Registry​

1. Check Postinstall Logs:
   • Locate the WSUS setup logs in:
     

      C:\Program Files\Update Services\LogFiles

   • Look for errors indicating what’s missing in the configuration.
2. Verify the SQL Instance in Registry:
   • Navigate to:
     

      HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server

   • Confirm that the instance MSSQL$MICROSOFT##SSEE exists.

---

Let me know what happens after these steps! If it still doesn’t work, share key portions of the WSUS logs to pinpoint the issue. We’ll get there—I promise this isn’t winning!

 

[bswhipp]

I am using SQL do I need to install WID?

 

[WindowsForum AI]

If you're already using SQL Server (and not WID) for your WSUS database, then no, you do not need to install WID. Instead, the issue lies in correctly configuring WSUS to use your SQL instance. Let’s focus on resolving this by properly linking WSUS with your SQL Server setup.

---

Verify SQL Server Configuration​

Here’s what we need to check to ensure WSUS works seamlessly with your SQL instance:

---

Step 1: Verify SQL Instance​

Confirm the name and state of your SQL Server instance where SUSDB is hosted. If unsure:

1. Open SQL Server Management Studio (SSMS) or connect via SQLCMD.
2. Query the existing databases:
   

   sql SELECT name FROM sys.databases;

   • If SUSDB exists, great! If not, you’ll need to create or reinitialize it (details in Step 3).
3. Ensure WSUS Has Permissions:
   • The SQL instance must allow connections from the WSUS Server.
   • Add the WSUS machine account (Domain\ServerName$) or NT AUTHORITY\NETWORK SERVICE as a login in SQL Server and grant it:
     • db_owner rights on SUSDB.
4. Confirm SQL is listening on the correct port (default: 1433 for TCP):
   • Use: SQL Server Configuration Manager > Network Configuration > Protocols for .

---

Step 2: Reconfigure WSUS to Use SQL​

Run the postinstall command again, specifying your SQL instance:

1. Use the Correct SQL Instance Name:
   Replace with the name of your SQL Server instance:
   

   bash wsusutil.exe postinstall SQL_INSTANCE_NAME="\" CONTENT_DIR="D:\WSUS"

   Example for a typical SQL Express instance:
   

   bash wsusutil.exe postinstall SQL_INSTANCE_NAME="MyServer\SQLExpress" CONTENT_DIR="D:\WSUS"

   If using the default SQL instance, drop the \SQLInstance:
   

   bash wsusutil.exe postinstall SQL_INSTANCE_NAME="MyServer" CONTENT_DIR="D:\WSUS"

   • Validate the Connection:
     If wsusutil fails, double-check:
     • The SUSDB exists.
     • SQL is accepting remote/TCP connections.
     • Firewall is allowing the SQL port (default: 1433).

---

Step 3: Create or Reinitialize SUSDB (if missing)​

If SUSDB doesn’t exist (or is corrupted), follow these steps to recreate it:

Option 1: Let WSUS Rebuild It​

1. Stop the WSUSService (to avoid conflicts):
   

   bash net stop WsusService

2. Run the postinstall command again. Provided WSUS has access to the SQL instance, it will automatically create SUSDB.

Option 2: Create SUSDB Manually​

If WSUS can’t create SUSDB, do the following:

1. Use SQL Server Management Studio (SSMS) or SQLCMD to manually create the database:
   

   sql CREATE DATABASE SUSDB;

2. Grant necessary permissions:
   

   sql USE SUSDB; CREATE USER [NT AUTHORITY\NETWORK SERVICE] FOR LOGIN [NT AUTHORITY\NETWORK SERVICE]; ALTER ROLE db_owner ADD MEMBER [NT AUTHORITY\NETWORK SERVICE];

3. Re-run postinstall with the proper SQL instance.

---

Step 4: Validate Logs​

If wsusutil.exe postinstall still fails, check the logs for more clues:

1. WSUS Log:
   • Located in:
     

      C:\Program Files\Update Services\LogFiles

   • Look for any lines mentioning SQL or communication failures.
2. SQL Logs:
   • Open SQL Server Management Studio (SSMS) or check under:
     

      C:\Program Files\Microsoft SQL Server\\MSSQL\Log

Key log entries can help identify whether the issue is with permissions, connectivity, or schema mismatches.

---

Step 5: Optional - Bypass SQL for Testing​

If technical challenges persist, you could switch to WID temporarily just to confirm WSUS functionality:

1. Install WID:
   

   bash Install-WindowsFeature -Name Windows-Internal-Database

2. Run:
   

   bash wsusutil.exe postinstall CONTENT_DIR="D:\WSUS"

Once WSUS is stable, migrate back to your SQL Server instance.

---

Let me know how this progresses, and feel free to share relevant log snippets if something still feels off. We’ll make sure WSUS and SQL get on speaking terms!

 

[bswhipp]

after the susutil.exe postinstall SQL_INSTANCE_NAME="Instance Name" CONTENT_DIR="D:\WSUS\WSUSCONTENT"
Post install is starting
Fatal Error: The system cannot find the path specified.

 

[WindowsForum AI]

The error "The system cannot find the path specified" indicates that WSUS is unable to locate the specified Content Directory or there’s an issue with the SQL instance connection during the installation. Let’s address this step by step:

---

Step 1: Verify the Content Directory Path​

Make sure the directory specified in the CONTENT_DIR parameter actually exists and has correct permissions.

1. Check if the Path Exists:
   • Navigate to D:\WSUS\WSUSCONTENT in File Explorer.
   • If it doesn’t exist, manually create it:
     

     bash mkdir D:\WSUS\WSUSCONTENT

2. Grant Correct Permissions:
   • The WSUS service (and SQL Server process if hosted locally) needs access to this directory:
     • Right-click the folder > Properties > Security Tab.
     • Add NT AUTHORITY\NETWORK SERVICE and grant Modify permissions.

---

Step 2: Confirm the SQL Instance Name​

Ensure the SQL_INSTANCE_NAME parameter is pointing to the correct SQL Server instance.

1. Check the SQL Server instance name:
   • Open SQL Server Configuration Manager or SQL Server Management Studio (SSMS).
   • Look for the full instance name (ServerName\InstanceName). Note:
     • Default instance: ServerName
     • Named instance: ServerName\YourInstance
   • Validate the instance is running.
2. Test connecting to the instance:
   • Run sqlcmd from the command line:
     

     bash sqlcmd -S ServerName\InstanceName -E

     (Replace ServerName\InstanceName with your actual instance name).
   • If it fails, troubleshoot connectivity (e.g., SQL Server service status, firewall rules on port 1433).

---

Step 3: Ensure WSUS Content Location Is Writable​

If WSUS doesn’t have permission to write to the directory:

1. Temporarily move WSUS content to the default location:
   

   bash wsusutil.exe postinstall SQL_INSTANCE_NAME="InstanceName" CONTENT_DIR="C:\WSUS"

   This bypasses potential issues with drive D.
2. Once configured, move the content folder back:
   • Use WSUS Console > Options > Server Cleanup Wizard > Clean up WSUS Data.

---

Step 4: Re-run WSUS Configuration​

Re-run the wsusutil.exe postinstall with the corrected parameters:

wsusutil.exe postinstall SQL_INSTANCE_NAME="ServerName\InstanceName" CONTENT_DIR="D:\WSUS\WSUSCONTENT"

Key points:

• Ensure D:\WSUS\WSUSCONTENT exists and has appropriate permissions.
• Ensure the SQL instance is reachable and the database is accessible.

---

Step 5: Check Logs for Specific Failures​

1. Open the WSUS logs:
   • Look at:
     

      C:\Program Files\Update Services\LogFiles

   • Files:
     • WSUSSetup.log
     • Change.log
2. Review SQL Error Logs:
   • Located under your SQL instance (e.g., C:\Program Files\Microsoft SQL Server\MSSQL\Log).

Share any relevant error messages if re-runs still fail! We'll identify whether it's an SQL or path issue.