WSUS server with SQL Server database configuration steps

Mohamed khairy 146 Reputation points
2024-08-04T09:41:42.44+00:00

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

Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
13,041 questions
Windows Server Management
Windows Server Management
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Management: The act or process of organizing, handling, directing or controlling something.
435 questions
0 comments No comments
{count} votes

Accepted answer
  1. Marcin Policht 23,545 Reputation points MVP
    2024-08-04T11:06:13.3066667+00:00

    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:


    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

    1 person found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.