Sounds like SQL Server was setup with Binary Sort as the default collation. I would also bet that all your column names, table names, etc are case sensitive as well. Also, all queries that use the default sort would also be case sensitive.

Binary Sort is a pain until you get used to it. Then it just becomes second nature. 🙂