Extended Stored Procedure
-------------------------

With the Microsoft SQL Server Option for Navision,
you can use Windows authentication to connect to a
Microsoft SQL Server. But this is only possible when the 
server's operating system is Windows 2000 or Windows 2003.

However, in order to use Windows authentication, you must 
add 2 extended stored procedures to each instance of SQL Server 
you want to access. 

To add the extended stored procedures, follow this procedure:

From your server computer, access the Navision 
Installation CD-ROM. In the folder $:\SQL_ESP, where the 
$ is the CD-ROM drive, click the file xp_ndo.exe. When 
prompted, enter the path to the BINN subfolder of the 
SQL Server installation folder. (The unzipped xp_ndo.dll 
file must be in this folder on SQL Server.) 

When Navision connects to the server for 
the first time, the program adds the extended stored 
procedure automatically. 

If the program detects that the server has already been accessed 
by Navision, it does not automatically add the 
extended stored procedure: you must add the extended stored 
procedure manually. 

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.

-----------------------------------------------------------------
This document is subject to change without notice and does
not represent any commitment on the part of Microsoft Business 
Solutions ApS, Denmark.

Microsoft Business Solutions ApS, Denmark assumes no responsibility 
for any faults or shortcomings in this document.