TableData 200000001 does not exist – FIXED!

Dynamics-NAV-logo-500x328Today I ran into the massage “TableData 200000001 does not exist” when trying to access a NAV 2013 database through Microsoft Dynamics NAV Development Environment. I did some research on the the web and found some suggestions but all of them suggested to add the user to db_owner on the SQL server. But I was not happy about the soloution to make any users member of “db_owner”.

I then found a workaround, by loading xp_ndo_64.dll into the SQL server it’s possible to use Windows Authentication. So I registered and executed “xp_ndo_64.dll” with the code below and made a new group in my AD and placed the users witch needed access to the database into the group and added a new Active Directory group to the SQL server under security and assigned the group “db_dataread” permissions and granted Shoplan to the group.

It did the trick.


USE master
EXEC sp_addextendedproc xp_ndo_enumusergroups, 'E:\MSSQL11.MSSQLSERVER\MSSQL\Binn\xp_ndo_64.dll'
GO

GRANT EXECUTE
ON [xp_ndo_enumusergroups]
TO PUBLIC
GO

USE master
EXEC sp_addextendedproc xp_ndo_enumusersids, 'E:\MSSQL11.MSSQLSERVER\MSSQL\Binn\xp_ndo_64.dll'
GO
GRANT EXECUTE
ON [xp_ndo_enumusersids]
TO PUBLIC
GO

Use "Database"
Go
grant showplan to [AD-Group\Nav-Query]
Go