Do you have your user name and password for the external data source specified under Manage External Data Sources? IWP/CWP cannot prompt the user for the additional database password, so it has to be embedded. I was having this same problem until I included the user name and password.
Clearly the issue you bring up makes a lot of sense. I however didnt think of it and felt as though i was constantly running into a brickwall. (I have never seen this topic documented in all my FM web searches) Then the light was turned . . . Thank you very much it's now working perfectly ! :smileyvery-happy: