'TableData 2000000001' doesn't exist and ndo problems

attardc

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?

thanks millions!

DenSter

You also need to grant execute rights to those esp's for the public role.

Administrator

[Topic moved from 'NAV Tips & Tricks' to 'SQL General' forum]

brpe

Please have a look at this:

http://www.brianp.dk/?p=338

LCosta

http://saurav-nav.blogspot.pt/2011/05/extended-stored-procedure-xpndodll.html

endotrio

Hello,

'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.

use [master]
GO
GRANT EXECUTE ON [dbo].[XXXXX] TO [UserYY]

On this source ypou have some steps how you can resolve it:

https://www.get-itsolutions.com/the-execute-permission-was-denied-on-the-object/