Link: Added: This issue depends TEIID-1291

Couple of things:

-   you're using the admin port of 31443 for jdbc queries.   you should be using the jdbc port, which defaults to 31000
-   in ER2, the admin port defaults to using the secure protocol of "mms"
-   the admin port and the jdbc port use different security domains.   so you could eventually have issues if you thought you added the user to the teiid-security-users.properties and tried to use that user id when connecting via the admin port.
-   as for querying using the admin port, this is an undocumented feature, and there are possible plans to tighten this down so that only admin calls can be made on this port.

If you can make the change to use port 31000 and retry, it would be appreciated.

It works with the jdbc port. I guess that the use of admin port changed between ER1 and ER2. It was possible to use the admin port on ER1 without problems.

From ER1 to ER2 the default secure protocol was changed to mms.   So existing test using the mm protocol on the admin port would fail.

As for using the admin port for jdbc queries, it's not a documented feature.  So please do not setup your test to use the admin port for queries.   The engineers are considering enforcing that the admin port not be used for jdbc queries.  

The use of the jdbc port, as recommended, was successful.   As for using undocumented features or future enhancements regarding how the admin and jdbc ports are used, please log an jira specific to the enhancement you would like to see.

Thanks for the advice.