[wix-users] DB not getting created in Program Files (x86) folder

[Ven H]

When I give the path for creating the DB (data and log files) in Program
Files (x86) folder in my MSI, I always get an error in the log, which is
not so helpful for troubleshooting. Initially, I thought, this could be due
to space, but tried on a server with lots of space, but there also, I get
the same issue. Upon some searching I found that it is because of
permission, but I am not sure how to fix it. Can anyone please help?