I have just migrated my NAV4 SP1 database from SQL 2000 to SQL 2008 through an SQL restore.
I' have windows authentication and various roles per user. Users with SUPER rights are getting the error that 'TableData 2000000001' does not exist.
Users with other roles are getting the error that 'The Execute permission was denied on the object 'xp_ndo_enumusergroups' database 'master' schema 'dbo'
I've registered the ndo procedures, any ideas?
RIS Plus, LLC
MVP - Business Apps
'The Execute permission was denied on the object 'xp_ndo_enumusergroups' database 'master' schema 'dbo' meaning that user has not permission to run 'xp_ndo_enumusergroups' stored procedure in master database. If you are database admin then you need to give permission to the user performing the execution like below.
GRANT EXECUTE ON [dbo].[XXXXX] TO [UserYY]
On this source ypou have some steps how you can resolve it: