Extended Stored Procedure
-------------------------
With the Microsoft SQL Server Option for Microsoft Business Solutions-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 XP, Windows 2000 or Windows NT 4.0.
However, in order to use Windows authentication, you must
add an extended stored procedure to each SQL Server you
want to access. To do so, follow this procedure:
From your server computer, access the Microsoft Business Solutions-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 been accessed
by Navision, it does not automatically add the
extended stored procedure: you must add the extended stored
procedure manually. To do so, 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_enumusersids.)
To do this go to Enterprise Manager, MASTER Database and right click Extended Stored Prodedures and select New. Ensure the name is xp_ndo_enumusersids.
After the extended stored procedure has been successfully added
to the server, you must grant execute permissions to the 'public' and 'guest'
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 the xp_ndo_enumusersids and
select Properties.
- Select Permissions and grant EXEC rights to
both 'public' and 'guest.'
To Update an Existing xp_ndo.dll File:
--------------------------------------
- Open Enterprise Manager.
- Expand the server and expand the databases.
- Expand the master database and the Extended Stored Procedures.
- In the right side panel, locate the xp_ndo_enumusersids and delete it.
- 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.
Add the extended stored procedure as described above.
