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!

1 comment:

  1. Period in the table name. That's the trick! Check your tables in the problem database, if there's any periods, remove them.

    ReplyDelete