Documentation for NAV 2009 SP1

ta5
ta5 Member Posts: 1,164
edited 2009-11-27 in NAV/Navision Classic Client
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

Comments

  • jannestig
    jannestig Member Posts: 1,000
    In your DVD directory

    \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
  • ta5
    ta5 Member Posts: 1,164
    Thanks.
    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.
  • jannestig
    jannestig Member Posts: 1,000
    To manually add the extended stored procedures, follow this procedure:

    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.
  • ta5
    ta5 Member Posts: 1,164
    Thanks very much. I know this information from the pre 2009 versions, but wanted the crosscheck with the 2009 SP1 documentation. But I still can't find the information for 2009 SP1, neither on the DVD nor on the internet. ](*,)
    A directory called SQL_ESPWIN64 does not exist on the 2009 SP1 DVD, but did always exist on the older installtion DVDs.

    Thanks
    Thomas
  • jannestig
    jannestig Member Posts: 1,000
    well i guess MS supposed it would never fail during install etc so left it out.

    But its an SQL side action so the process is the same

Categories