Developer Workstation Installation

When you are going to use a fresh copy of a NAV administration, please follow these steps. A fresh copy means an administration to which no connections have yet been made. If this is not the case, these steps can be skipped.

Enable the trace flag 4616 in the SQL server instance:

Step 1: Go to the SQL Server Configuration Manager.

Step 2: Select 'Services', click right on the 'SQL Server' instance, and click 'Properties'.

Step 3: Go to the 'Advanced' tab and add ';-T4616' at the end of the 'Startup Parameters' property.

Step 4: Restart the 'SQL Server' service.

Add an extended stored procedure to the SQL Server instance:

Step 1: Copy the 'xp_ndo.dll' file from your MS Dynamics NAV installation disk to your SQL servers '\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\' folder.

Step 2: Go to the SQL Server and open the 'master' database.

Step 3: Go to 'Extended Stored Procedures' ('master > Programmability > Extended Stored Procedures').

Step 4: Click right on it and select 'New Extended Stored Procedure'.

Step 5: The name of the EXP must be 'xp_ndo_enumusergroups'.

Step 6: The linked dll must be the 'xp_ndo.dll' you have copied.

Step 7: Open the 'Permissions' page, add the '[public]' role and give the 'Execute' permissions to it by checking the check-box in the 'Grant' column.