Upgrading Microsoft Dynamics GP Error: The stored procedure smGrantAccessOnAccountMSTR returned the following results: DBMS: 0 Microsoft Dynamics GP

Oh the joys for upgrades, right?   There are always those fun upgrade error messages when you look at it and say, now what does this mean, I'm almost to the end and you fail on me NOW!

Let's dissect this error message a bit more to help you get past it.

This error typically happens at the end when you are running Miscellaneous Scripts part of the upgrade.

The stored procedure smGrantAccessOnAccountMSTR returned the following results: DBMS: 0 Microsoft Dynamics GP

The stored procedure it is failing on is simply a statement similar to the grant script; it is giving DYNGRP access to various GL tables. It also validates and creates various triggers, so if you have any custom triggers or third parties in place, these could interfere with the triggers we are trying to put down.

Often times this error is caused by a table in the database having a period in the name, so if you haven’t already done so I would recommend checking for that.

The below script should tell us something if you run it in SQL Server Management Studio

 exec smGrantAccessOnAccountMSTR