As a test use the same user in CF as you used in Query analyzer. And make sure you test with "standard" (not integrated AD) permissions.

A couple of questions to ask:

1) Are you binding the values with cfqueryparam?

2) What's the JDBC driver set up? Is CLOB enabled for example? How big is the buffer?

Perhaps you...