Microsoft Dynamic Nav 2009 and SQL Server 2008 R2

Business Central/NAV User Forum
1

is Microsoft Dyanamic Nav 2009 compatible with sql server 2008 R2?

i try to create a new database but didnt work any idea?

2

Yes, it is compatible.

Can you provide more details on your problem?

3

0363.error nav.jpg
0363.error nav.jpg1280×800 140 KB

4

add the xp_ndo_x64.dll to the binn folder. Run the following code in SQL query

USE master
EXEC sp_addextendedproc xp_ndo_enumusergroups, ‘C:\Program Files\Microsoft SQL Server\MSSQL\Binn\xp_ndo_x64.dll’
GO

GRANT EXECUTE
ON [xp_ndo_enumusergroups]
TO PUBLIC
GO

Similarly for

xp_ndo_enumusersids

5

i try to do this and still not working

when i run the code in sql query it says :" the object xp_ndo_enumusergroups already exist in the database"

Any idea ?

6

Make sure that xp_ndo_enumusergroups is refering to correct dll…

7

Make sure it’s in the Master DB and not your NAV DB