Microsoft Dynamics NAV error message

Asked By Sandy William 0 points N/A Posted on - 11/11/2011

                        I am using Microsoft Dynamic NAV and trying to log on using windows authentication. But I always encounter this problem. I don’t have any Idea why this error pop ups. I searched internet about this problem but nothing solved. Please help me to find out and what solution do I need to do.  I need someone who is familiar using it and how to solve this problem.

 

Microsoft Dynamics NAV

The extended stored procedure xp_ndo_enumusergroups in the library file xp_ndo.dll, is not available on the QUARTERMASTER server.

Until this procedure and library have been added, it will not possible to connect to this server from Microsoft Dynamics NAV with Windows Authentication, but you will still be able to connect with Database Server Authentication.

You can read more about adding this extended stored procedure in the help pages on the product CD. Follow the hyperlink to the readme.txt file on the Servers page under the Documentation section of SQL Server.

• Status: Open
• Question Views: 2254
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Works

Answered By Rogers U 10 points N/A #109253

Microsoft Dynamics NAV error message

Sandy William

The issue is with the permissions on the eumusergroups and enumuserids database.

In order to resolve this you have to manually grant these permissions, and copy the xp_ndo.dll file to the required location.

This file is located under D:SQLDatabasePFilesMicrosoft Dynamics NAV60Database” on the product DVD/CD.

After copying this file run the following scripts:

USE master

EXEC sp_addextendedproc xp_ndo_enumusersids, ‘C:[Location of file]xp_ndo.dll’

GO

 

GRANT EXECUTE

ON [xp_ndo_enumusersids]

TO PUBLIC

GO

 

USE master

EXEC sp_addextendedproc xp_ndo_enumusergroups, ‘C: [Location]xp_ndo.dll’

GO

 

GRANT EXECUTE

ON [xp_ndo_enumusergroups]

TO PUBLIC

GO

After this Re-Start the system

Wish you luck

Rogers

About Rogers U

Questions
1

Answers
26

Best Answers
5

• Vote Up 0 Vote Down

• Posted on - 11/12/2011
• Question Category: MS Works