is it possible to configure WSUS server in azure with SQL paas database

Abhishek Singh 381 Reputation points
2020-11-11T11:49:14.683+00:00

is it possible to configure WSUS server in azure with SQL PAAS database , instead of IAAS sql db
https://learn.microsoft.com/en-us/azure/architecture/example-scenario/wsus/

SQL Server on Azure Virtual Machines
Azure SQL Database
Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
7,080 questions
{count} vote

Accepted answer
  1. prmanhas-MSFT 17,886 Reputation points Microsoft Employee
    2020-11-16T08:29:34.07+00:00

    @Abhishek Singh Thank you for your patience over the matter!!!

    Below is the response I got from our Product Group:

    No, it is not possible to configure WSUS server in azure with SQL PAAS database. About a year and a half ago, there was some exploration to see if it would work and discovered there would have to be changes to WSUS. We suggest that customers follow the software requirements for WSUS which is to either use the Windows Internal Database (WID) on the WSUS server, or to use an in support version of Microsoft SQL Server.

    The background here is that Azure SQL does not support Windows Authentication. WUS relies on Windows Authentication to access the DB.

    Hope it helps!!!

    Please "Accept as Answer" if it helped so it can help others in community looking for help on similar topics.

    1 person found this answer helpful.
    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Tapas Kumar Barik 1 Reputation point
    2022-08-06T05:09:20.81+00:00

    Is it still possible to use Azure sql in WSUS (Windows Server update services) server?