Fix.
Review sql permissions on roles such as X3_ADX_SYS, compare with a working system. Consult a database administrator for assistance.
You need to create inbound and outbound rules on windows server and client machine,
https://www.youtube.com/watch?v=3Eyva0OG2tc&ab_channel=SoftSolution
https://support.na.sage.com/selfservice/viewContent.do?externalId=83169&sliceId=1
Necroposting for Posterity if you are coming in from a Google Search: Connection to server failed : X3 engine error: The SELECT permission was denied on the object 'APLLCK', database 'x3v12', schema 'DEV'. : ini_com:Variable dimension:!(2)
*Community Hub is the new name for Sage City