@Pongpon Nilaphruek Welcome to Microsoft Q&A, Thank you for posting your here!!
I would recommend you to create the VMSS from a custom image. You could first deploy a VM (by selecting desired OS) and all required application, configurations and DBMS need to be installed on the VM then make this as a custom VM image(By running Sysprep to create generalized image). Now deploy the VMSS or scale set with the same custom image to serve your application traffic.
Steps to follow
1)Create and customize a VM
2)Deprovision and generalize the VM
3)Create a custom VM image
4)Deploy a scale set that uses the custom VM image
You could make it with multiple methods as below
Tutorial: Create and use a custom image for virtual machine scale sets with Azure PowerShell
Tutorial: Create and use a custom image for virtual machine scale sets with the Azure CLI
Add a custom image to an Azure scale set template
Additional Information :https://learn.microsoft.com/en-us/azure/virtual-machine-scale-sets/overview#why-use-virtual-machine-scale-sets
Hope this helps!
Kindly let us know if the above helps or you need further assistance on this issue.
-------------------------------------------------------------------------------------------------------------------
Please do not forget to "Accept the answer” and “up-vote” wherever the information provided helps you, this can be beneficial to other community members.