Skip to Content

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.

Alex Lim is a certified IT Technical Support Architect with over 15 years of experience in designing, implementing, and troubleshooting complex IT systems and networks. He has worked for leading IT companies, such as Microsoft, IBM, and Cisco, providing technical support and solutions to clients across various industries and sectors. Alex has a bachelor’s degree in computer science from the National University of Singapore and a master’s degree in information security from the Massachusetts Institute of Technology. He is also the author of several best-selling books on IT technical support, such as The IT Technical Support Handbook and Troubleshooting IT Systems and Networks. Alex lives in Bandar, Johore, Malaysia with his wife and two chilrdren. You can reach him at [email protected] or follow him on Website | Twitter | Facebook

    Ads Blocker Image Powered by Code Help Pro

    Your Support Matters...

    We run an independent site that is committed to delivering valuable content, but it comes with its challenges. Many of our readers use ad blockers, causing our advertising revenue to decline. Unlike some websites, we have not implemented paywalls to restrict access. Your support can make a significant difference. If you find this website useful and choose to support us, it would greatly secure our future. We appreciate your help. If you are currently using an ad blocker, please consider disabling it for our site. Thank you for your understanding and support.