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

Chat now with support

Return

Feedback submitted.

Was this article helpful?

[Select Rating]

Title

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

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:
"Object reference not set to an instance of object"
Cause

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

WORKAROUND: Run the following to give access to VIEW DEFINITION
GRANT VIEW ANY DEFINITION TO PUBLIC
Or

GRANT VIEW ANY DEFINITION TO <user>

STATUS: Waiting for fix in a future release of Toad for SQL Server.
Defect ID

ST72420
Additional Information

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

Feedback submitted.

Was this article helpful?

[Select Rating]

Title