Seems to suggest it's using the wrong dialect. (SQL server should use [] or "" for identifier quotes, not backticks)
Are you setting this.ormsettings in your Application.cfc? If so it should be set to a SQLServer dialect... In hibernate it would be "SQLServer".. Assuming it's the same in CF ORM but others will probably correct me if wrong.
-G