The solution from this article solved the problem for me.

http://social.msdn.microsoft.com/Forums/is/sqlsecurity/thread/9d054247-3b4e-4794-92d0-04b94eddcd9f