Now that I have synchronized the IWAM_User account between the Active Directory and the IIS Meta table, I was now able to resolve the issue of my VFP COM object from VFP by the use of CreateObject(). This was resolved ok on one server. However, the other server still returns "80020009: Exception occured" when I try to CreateObject() from VFP. This only happens if I create the COM DLL within a Component Services package. Basically, whatever component I try to create in that package or any other package return the same.
So, just to recap, the sychronizing when well on both servers. Having done that, it resolved the issue on one server but no the other one.
This exception occured error is pretty vague. So, it doesn't help that much to know what I should look for.