Forum Discussion
RemyaKrishnan
Oct 24, 2022Copper Contributor
WSUS DB Migration
We are planning to migrate SQL Server 2019 connected to Microsoft WSUS Application onto A SQL Server on Azure PaaS? Please advise whether Microsoft WSUS Application compatibility with SQL Server on Azure PaaS?
1 Reply
Sort By
- Chandrasekhar_AryaIron ContributorBelow is the response I got from our Product Group around 2021
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.