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?