Hi
Where on the installer DVD is the section for the extended stored procedures xp_ndo_enumusersids and xp_ndo_usergroups?
In pre 2009 Version it was in w1w1isql.pdf...
I know, there is now the nav_install.chm, but I can't find it there ](*,)
Thanks in advance
Thomas
0
Comments
\Documentation\PFiles\Microsoft Dynamics NAV\60\Documentation\Install Guides
Or there is also the NAV PRO developer on MSDN which you can also download off partnersource
XP files under
SQLDatabase\PFiles\Microsoft Dynamics NAV\60\Database
Yes, I can find this directory, but the pdf files there are for EP, NACG, etc. and in the nav_install.chm I cant find the info I'm looking for.
Using a Microsoft tool such as Enterprise Manager, add the
file to the extended stored procedures already installed on
SQL Server. (The name of the extended stored procedure must
be xp_ndo_enumusergroups and xp_ndo_enumusersids.)
After the extended stored procedure has been successfully added
to the server, you must grant execute permissions to the "public"
role by following this procedure:
- Open Enterprise Manager.
- Expand the server and expand the databases.
- Expand the master database and the Extended Stored Procedures.
- In the right side panel, right-click xp_ndo_enumusersids and
xp_ndo_enumusergroups and select Properties.
- Select Permissions and grant EXEC rights to "public."
To Update an Existing xp_ndo.dll File:
If you have upgraded to the SQL Server Option for Navision 4.0
you must copy the new xp_ndo.dll file to all the instances of
SQL Server in your network.
- Stop the server before you copy the dll. This ensures that the
old dll is not loaded and is overwritten by the new dll.
- Locate the xp_ndo.exe self-extracting file on the product CD.
- Extract it so that it overwrites the existing dll file which is
stored in the BINN subfolder of the SQL Server installation folder.
The new dll contains a new extended stored
procedure - xp_ndo_enumusergroups. If you are going to connect
to SQL Server with an older version of the Navision client,
the old extended stored procedure xp_ndo_enumusersids should
also be added to the server.
The installation program for Navision 4.0 installs the dll and
adds both of the stored procedures to the server.
SQL Server 2000 - 64 bit
If you are running on SQL Server 2000 - 64 bit, you must use
another compiled version of xp_ndo.dll. This can be found on
the Navision Installation CD-ROM, in the folder $:\SQL_ESP\WIN64,
where the $ is the CD-ROM drive.
To add the extended stored procedure, follow the instructions
described above.
A directory called SQL_ESPWIN64 does not exist on the 2009 SP1 DVD, but did always exist on the older installtion DVDs.
Thanks
Thomas
But its an SQL side action so the process is the same