We've been going insane lately trying to work out why some of our SQL Server 7.0 datasources work with CFMX and why others don't. We had a multitude of bizarre test cases that seemed to indicate that SA always worked while other database users were refused. Turns out there is a bug in the ColdFusion Administrator datasource interface but happily it has nothing to do with the SA account.
CF Administrator will not allow passwords greater than 16 characters for any datasource. This is not really an issue with the underlying CFMX engine - just an issue with the CF Administrator application. If you attempt to create or edit a datasource with a password of 17+ characters it simply gets truncated to 16 and obviously never works.
Our SA password just happened to be one of the only database passwords short enough to not get chopped (um.. no it wasn't blank :) Oddly enough, despite our best endeavours we were unable to work this out on our own. We picked up on the bug from a post by the folks at Tanjents who confirmed the issue with Macromedia earlier this month.
Tanjents also outline a potential solution if you absolutely must have passwords longer than 16 characters but I'll refer you to their full post for that. (I located Tanjents post by reviewing the, referrers of the http://fullasagoog.com/ web site, then having a snoop about - what a web we all weave...)
Posted by modius at 04:11 PM | Permalink