WSUS server with SQL Server database configuration steps

Question

hi everybody

can anyone provide me with a reference for step by step guide to install and configure WSUS on SQL server ,This steps should include the SQL instance installation required for WSUS

Regards

Answer 1

Install SQL Server

1. Mount the SQL Server ISO: Mount the ISO file for SQL Server and run the setup as an administrator.
2. New SQL Server Installation: Select "New SQL server stand-alone installation" during the installation process.
3. Follow the Installation Wizard:
   • Accept the license terms.
   • Install necessary updates.
   • Select the "Database Engine Services".
   • Name your SQL instance.
   • Specify the service accounts and add SQL administrators.
   • Complete the installation.

Install WSUS Role

1. Add Roles and Features: Open the Server Manager and click on "Add Roles and Features".
2. Role-Based Installation: Select the appropriate server and choose "Windows Server Update Services (WSUS)".
3. Select Features: Validate dependencies and proceed.
4. Select Database: Uncheck "WID Connectivity" and check "SQL Server Connectivity".
5. Specify SQL Server: Enter the SQL Server name (e.g., SERVER\INSTANCE) and check the connection.

Post-Installation Configuration

1. Run Post-Installation Tasks: After WSUS installation, run the post-installation tasks from the Server Manager.
2. Configure WSUS: Launch the WSUS Administration Console and follow the wizard to complete the configuration.

For a detailed step-by-step guide, you can refer to:

• Install WSUS with a SQL Server Database on RDR-IT​ (RDR-IT)​
• SCCM installation: install SQL and WSUS on Network Pioneers​ (Net Pioneers)​. Post-Installation Configuration
  1. Run Post-Installation Tasks: After WSUS installation, run the post-installation tasks from the Server Manager.
  2. Configure WSUS: Launch the WSUS Administration Console and follow the wizard to complete the configuration.

For a detailed step-by-step guide, you can refer to:

• Install WSUS with a SQL Server Database on RDR-IT​ (RDR-IT)​
• SCCM installation: install SQL and WSUS on Network Pioneers​ (Net Pioneers)​.

---

If the above response helps answer your question, remember to "Accept Answer" so that others in the community facing similar issues can easily find the solution. Your contribution is highly appreciated.

hth

Marcin