Installing WSUS Server Role on Windows Server 2012 with Microsoft SQL Database

  • Article

Introduction

This article uses the same core steps to install WSUS Role on Windows Server 2012 as the article Step 2: Install the WSUS server role. The only change in this article is related to which database WSUS will use, in this case it will be Microsoft SQL Server.

Installing WSUS Role

1. Log on to the server on which you plan to install the WSUS server role by using an account that is a member of the Local Administrators group.

2. In Server Manager, click Dashboard, and then click Add roles and features.

3. On the Before you begin page, click Next.

4. In the Select installation type page, confirm that Role-based or feature-based installation option is selected and click Next.

5. On the Select destination server page, choose where the server is located (from a server pool or from a virtual hard disk). After you select the location, choose the server that you want to install the WSUS server role, and then click Next.

6. On the Select server roles page, select Windows Server Update Services. 

  1. In the Add Roles and Features Wizard dialog box, click Add Features, and then click Next.

8. On the Select features page, leave the default selections, and then click Next.
Note: WSUS only requires the default Web Server role configuration. If you are prompted for additional Web Server role configuration while setting up WSUS you can safely accept the default values and continue setting up WSUS.

9. On the Windows Server Update Services page, click Next.

10. On the Select Role Services page, select Database, uncheck WID (both can't be used at the same time), and then click Next.

  1. On the Database Instance Selection page type the name of the SQL Server (MachineName\Instance) and click Check Connection. If the connection between WSUS and SQL Server is working properly you can click Next to proceed.

  2. On the Content location selection page, type a valid location to store the updates, and then click Next.

13. On the Confirm installation selections page, review the selected options, and then click Install.

14. On the Installation progress page, make sure that the installation succeeded, and then click Close.

15. In Server Manager, verify if a notification appears to inform you that a restart is required. This can vary according to the installed server role. If it requires a restart make sure to restart the server to complete the installation.

At this point you can follow Step 3, which is Configure WSUS Server.