Thanks for posting.
FileMaker 10 and it's ODBC driver support MS SQL Server 2008 for use as an external data source so I don't believe this is a compatibility issue. Instead, this appears to be a known limitation between FileMaker's ESS feature and Windows NT Authentication. Please see knowledge base answer #6675 for more information:
That fixed it. Thanks for your help!