Install WSUS

If you plan on using Software Updates you need to install WSUS

\

Since we installed SQL we need to ensure we uncheck WID Windows Internal database

We will use the SQL Server Connectivity

Create a folder in Drive - MEMCM_Content_LIB called WSUS

Use the path to the new WSUS folder for updates location

For database instance use the Server name

Check Connection

Once install is complete

Perform Post-Deployment task for WSUS install to install the DB

Now time to increase cue length in IIS so WSUS performs better for MEMCM

Launch IIS

Increase WsusPool Queue Length to 2000

Increase the WsusPool Private Memory limit by 4 times or set to zero for unlimited

Now lets stop WSUSPool since we created created a Disk just for the DB

Also stop the WSUS Service

Open SSMS

Navigate to SUSDB > Properties

\

Files > Copy path of SUSDB

C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA

Navigate to path copied

With path open Detach the Database

Choose Drop connection

Go back to open folder

Select the following

  • SUSDB.mdf

  • SUSDB_log.ldf

CUT both files

Navigate to Drive - MEMCM_SQL_WSUS and the folder Database

Paste both files

Go back to SSMS and attach Database

Select Add

Use location where we just Pasted the Database

W:\Database

Select SUSDB.mdf

Verify everything looks correct the click OK

You can verify DB is reattached and points to the new location

Start WSUS Service

Start IIS WSUSPOOL

Last updated

Was this helpful?