Developer Workstation Installation

Setup NAV

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:
• • Go to the SQL Server Configuration Manager;
  • Select 'Services', click right on the 'SQL Server' instance, and click 'Properties';
  • Go to the 'Advanced' tab and add ';-T4616' at the end of the 'Startup Parameters' property;
  • Restart the 'SQL Server' service.

• Add an extended stored procedure to the SQL Server instance:
• • 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;
  • Go to the SQL Server and open the 'master' database;
  • Go to 'Extended Stored Procedures' ('master > Programmability > Extended Stored Procedures');
  • Click right on it and select 'New Extended Stored Procedure';
  • The name of the EXP must be 'xp_ndo_enumusergroups';
  • The linked dll must be the 'xp_ndo.dll' you have copied;
  • Open the 'Permissions' page, add the '[public]' role and give the 'Execute' permissions to it by checking the check-box in the 'Grant' column.