Solved: How do I change the WSUS (Windows Server Update Services) SQL Server Port

Problem Symptom

If you ever need to use a different SQL Server Instance port for WSUS other than the default of 1433. This assumes you have already installed WSUS and configured it to work with an existing SQL Instance.

Change the SQL port on WSUS SQL Instance

Step 1: Open SQL Server Configuration Manager.

Step 2: Connect to the SQL server where the WSUS Instance is running.

Step 3: Expand SQL Server Network Configuration and click on Protocols for (your instance name).

Step 4: Right-click on the TCP/IP node on the right side of the window. Select the Properties option from the context menu.

Step 5: Click on the IP Addresses Tab.

Step 6: Scroll to the bottom of the window to locate the IPAll.

Step 7: Make sure TCP Dynamic Ports is empty and then enter the port you want to use for WSUS in the TCP Port section.

Step 8: Restart the SQL Server (your instance name) Service to apply the new port setting.

Change port setting on WSUS server

Step 9: Login to server that is running the WSUS server role.

Step 10: Open a PowerShell command window in Admin mode.

Step 11: Enter the following command to stop both the iisadmin and wsusservice services:

stop-service iisadmin,wsusservice

Step 12: Execute the following command to start postinstall.

cd c:\program files\update services\tools

.\wsusutil.exe postinstall SQL_INSTANCE_NAME=your database server name\your wsus instance name, new wsus sql port number

Example:

.\wsusutil.exe postinstall SQL_INSTANCE_NAME=dbsrv.local\wsus,50321

Once the postinstall command has been completed you can check the registry to verify the port number is now being used.

Step 13: Open the Registry Editor (regedit).

Step 14: Navigate to:

HKLM\SOFTWARE\Microsoft\Update Services\Server\Setup

Step 15: Look for SqlServeName and verify if the port number is listed after your SQL Server\Instance name.

Restart iisadmin and wsusservice Services

Step 16: Enter the following command in same PowerShell window to start both the iisadmin and wsusservice services:

start-service iisadmin,wsusservice

Step 17: Start the WSUS MMC (Management Console) to verify that WSUS is now talking to the WSUS database instance using the new port.