Tuesday 2 June 2020

Error: the stored procedure smgrantaccessonaccountmstr returned the following results dbms:0 Microsoft Dynamics GP

So you receive the above error on doing an update/upgrade.

You have re-run the grant sql script, change db owner, etc, multiple times.

Even reviewed the stored procedure.

Reason for issue:
-There is a mis-named table. Possibly with a period in the name.

Resolution:
- Just rename the table.
-Continue to utilities.

Voila!

No comments:

Post a Comment