Install WSUS with a SQL Server database

Presentation

Since Windows 2016 server, it is possible to install the Windows Server Update Service (WSUS) directly with a SQL Server database.

In this article we will see how to proceed.

Prerequisites

To install WSUS with a SQL Server database you need:

  • Windows 2016 or 2019 server for the WSUS role
  • An instance of SQL Server (Express) that can be installed on the WSUS server.

Install the WSUS role

From the server manager, click Add Roles and Features 1 .
Server manager

When launching the wizard, click Next 1 .
Features wizard

Select Role Based Installation or 1 Functionality and click Next 2 .
Select role

Select server 1 and click Next 2 .
Select server

Check the box for Windows Server Update Services (WSUS).
Select WSUS

Validate dependencies by clicking Add features 1.
validate dependencies

Click Next 1 .
valid feature

Click Next 1 , no functionality is needed.
click next

A summary of the WSUS role is displayed, click Next 1 .
Resume WSUS

Uncheck WID connectivity 1 box and check SQL Server Connectivity 2 then click Next 3 .
Select SQL Server

Configure the storage location for 1 updates on the server and click Next 2 .
Configure folder

Configure access to the SQL server (SERVER\INSTANCE) 1 and click on Check connection 2 .
specify sql server

Once the connection is validated 1 , click the Next 2 button.
connection established

A summary of the IIS role is displayed, click Next 1 .
IIS overview

Validate IIS features by clicking Next 1 .
IIS Features

Confirm the installation by clicking Install 1 .
Start install

Wait during the installation …
wait wait

When the installation is complete, exit the wizard by clicking Close 1 .
installation completed

Now that WSUS roles and features are installed, you must run the post-installation tasks that will create the database. On the server manager, click on the notification icon 1 and then on Launch post-installation tasks 2 .
tasks post install

Wait during the execution which may take several minutes.
wait

The WSUS service is now installed and ready to be configured.
ready to configure

At the location configured to store the databases on the SQL Server instance, you can see that the SUSDB database files have been created.
Databases files SUSDB

Configuration

Launch the WSUS Administration Console to launch the configuration wizard.
Console WSUS

For the rest of the WSUS configuration, I invite you to read the tutorial: Installing and Configuring WSUS on Windows Server that explains how to configure and install the service.



Related Posts


SQL Server: Set up a backup plan

Introduction In this article, I will explain how to set up a backup plan with SQL Server. In this tutorial, we will use the wizard available in SSMS to configure the database to save as well as the sc

SQL Server Restore a Database from a Backup (BAK)

Introduction In this tutorial, I will show you how to restore a SQL Server database from a backup file (BAK). To perform the restore, you must have SQL Server Manager Studio (SSMS). Restore a database

MDT: Install updates with WSUS

Presentation In this tutorial, I'll explain how to enable Windows updates to a WSUS server when deploying an image with MDT. Enable updates Open the properties of an installation sequence, go to the T

Scroll to Top