Ugh. Here’s the thing. The advice below works, but “simplified, is a bit of a misnomer. The process is just way more work than it should be. Anytime you see “Run a DEXSQL log” this is not a simple process. The irritating part is that GP Power Tools does a much better job of this with a nice UI.
Microsoft Dynamics GP KB 857086 – You don’t have security privileges to this window. Contact your system administrator for assistance – Simplified – Microsoft Dynamics GP Community
Install, Upgrade & AdminMicrosoft & the GP Ecosystem
Archived post from 2017. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.