What do extended store procedures in XP_NDO.DLL do

radiant

We have had several clients that have tight controls on their servers and have asked us exactly what the two extended stored procedures (xp_ndo_enumsusergroups and xp_ndo_enumsids) do to the SQL server. All I have been able to find out is that they are needed to use windows authentication with NAV.

Can anyone elaborate on what these procedures actually do to the SQL installation?

-Radiant Technologies.

DenSter

They don't do anything to the SQL Server installation, they are used by the NAV application to enable Windows authentication. One is to accommodate the standard security model and the other for the enhanced security model.

azerty74

These extended stored procedures are needed to be able to use Windows Authentication with Dynamics NAV running on Sql Server.

The 2 versions (usergroups and usersids) are used depending if you choose the standard or enhanced security model.

In this whitepaper you will find a complete explanation:
Synchronizing Security in Microsoft Dynamics NAV 4.0 SP2

Mind that there is an error in the name of the whitepaper. Only starting from Dynamics NAV 4 SP3 you have the possibility to choose between security models.

kine

You can just run the SPs to see the output. It is a list of data from Active Directory. It is used as central point for reading data from AD, in this case client itselfs do not need any functionality to read the AD and is using SQL tools to read the data...

kriki

[Topic moved from Navision forum to SQL General forum]