BAM is not supported when SQL Server is set to Mixed Authentication Mode


Tiho has a good entry on why it is that way and how to fix it. He also explains how to diagnose the problem.