Schema compare gave "Object reference not set to an instance of object" only with SQL Server Auth (73025)

I am doing a Schema Compare. If the source and target are Windows Authentication, the Schema Compare runs. But if one of the compared schemas is SQL Server Authentication, I am able to run through the compare wizard but the compare finishes with the error:

Issue only with SQL Server Authentication Users that do not have rights to VIEW DEFINITION.

WORKAROUND: Run the following to give access to VIEW DEFINITION

GRANT VIEW ANY DEFINITION TO PUBLIC

This issue might only affect SQL Server Authentication Users for SQL Server 2005.