xp_ndo_enumusersids and xp_ndo_enumusergroups?

(0) Share

Report

Posted on by Community Member

Hi there, we run lots of Nav implementation all over the network but in any standalone or Always On organization we have these system stored procedures.

According my lectures we have different level domain users as login/users in each database. Apart of that we have for every user a schema with the same name. (I suppose for internal Nav control)

So far so good, and then, we have an application role and schema $ndo$shadow

When you start Nav client first read $ndo$dbproperty and $ndo$serverproperty tables for fetching some parameters; in our case this last table does not exist all and we have $ndo$dbconfig table as well but is empty in all the implementations.

Then will use $ndo$shadow application role and then for the concrete login call to this own Application Role that starts with this tag:

[$ndo$ar$..............

However I don't find in master database in both xp_ndo_enumusersids and xp_ndo_enumusergroups. What does it mean not having these stored procedures in our system? How does it affect us?

Thanks indeed for your responses and time,

*This post is locked for comments

All responses (6)

Answers (0)

Community Member on at

Like (0)

Report

RE: xp_ndo_enumusersids and xp_ndo_enumusergroups?

Hi ya Tharanga, no, no issue at all in our Navision live... I mean, other day trying to understand Navision security read an article talking about the security.. In our system, we have different level domain users as login/users in each database. Apart of that we have for every user a schema same name.

We also have an application role and schema $ndo$shadow

When you start Nav client first read $ndo$dbproperty table for fetching some parameters..

$ndo$shadow application role supposedly will call xp_ndo_enumusersids and xp_ndo_enumusergroups system stored procedures but these ones are not installed in master database.

I don’t know why and don’t know how can it impact in our system and what does it really mean not having them in live.

So, insist my system works properly.
Tharanga Chandrasekara 23,116 on at

Like (0)

Report

RE: xp_ndo_enumusersids and xp_ndo_enumusergroups?

Can you please explain bot more on your issue.
Community Member on at

Like (0)

Report

RE: xp_ndo_enumusersids and xp_ndo_enumusergroups?

Hi, it is not possible. We don't have in any NAV implementation (15) these system stored procedures. How is it possible? Unless that these objects are hidden, I doubt that.

We run Nav Classic Client

Thanks for any clarification on that!
Suggested answer

Rabin 2,976 on at

Like (0)

Report

RE: xp_ndo_enumusersids and xp_ndo_enumusergroups?

Hi,

Dynamics NAV System requires two extended stored procedures( DLLs that an instance of SQL Server can dynamically load and run) from xp_ndo.dll to exist on SQL Server if Windows logins are used. If these extended stored procedures do not exist, you will get this error when trying to log on using Windows Authentication:

Until this procedure and library have been added, it will not be 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 this link to resolve the issue...

blogs.msdn.microsoft.com/.../basic-sql-creating-extended-stored-procedure-xp_ndo-dll
Tharanga Chandrasekara 23,116 on at

Like (0)

Report

RE: xp_ndo_enumusersids and xp_ndo_enumusergroups?

Microsoft Dynamics NAV requires two extended stored procedures from xp_ndo.dll to exist on SQL Server if Windows logins are used. If these extended stored procedures do not exist, you will get this error when trying to log on using Windows Authentication.

https://blogs.msdn.microsoft.com/nav_developer/2008/11/05/basic-sql-creating-extended-stored-procedure-xp_ndo-dll/

Refer the forum answers : https://community.dynamics.com/nav/f/34/t/13864

Hope this will help and if you need additional support let us know.
Suggested answer

Roberto Stefanetti 12,998 on at

Like (0)

Report

RE: xp_ndo_enumusersids and xp_ndo_enumusergroups?

hi,

about xp_ndo_enumusersids and xp_ndo_enumusergroups

Scope

You should now have two extended stored procedures, and should be able to use Windows login from NAV. "

old sql server extended stored procedures based on "xp_ndo.dll"

look here

blogs.msdn.microsoft.com/.../basic-sql-creating-extended-stored-procedure-xp_ndo-dll