Category Archives: Navision

Minimium Permissions for User sync in Nav 9

To create a new user with a account that is not sysadmin you have to do this:

Give SecurityAdmin Fixed server role

Giveuser DB owner rights database role on Navision DB

Give user DB_accessadmin database role on Master database

Give user Grant on Select permissions for sys.sysprocesses  (grant select on sysprocesses to [domain/user]  with grant option)

Navision 2013 delete users

If you want to delete all users on a Navision 2013 you have to run this in the SQL on the database that Navision is using:

truncate table [dbo].[access control]
truncate table [dbo].[user]
truncate table [dbo].[user property]
truncate table [dbo].[page data personalization]
truncate table [dbo].[user default style sheet]
truncate table [dbo].[user metadata]
truncate table [dbo].[user personalization]

Use Windows Login with Navision

If you want to use your windows login as login for Navision you have to do this:

1. Copy the xp_ndo.dll file to the location you want store it. The file can be found under “D:\SQLDatabase\PFiles\Microsoft Dynamics NAV\60\Database” on the product DVD.
2. Run the following SQL command to add the stored procedures.

USE master
EXEC sp_addextendedproc xp_ndo_enumusersids, ‘C:\[Location of file]\xp_ndo.dll’
GO

GRANT EXECUTE
ON [xp_ndo_enumusersids]
TO PUBLIC
GO

USE master
EXEC sp_addextendedproc xp_ndo_enumusergroups, ‘C:\ [Location of file]\xp_ndo.dll’
GO

GRANT EXECUTE
ON [xp_ndo_enumusergroups]
TO PUBLIC
GO

Setup native Navision

Step by step to setup a Native Navision server

1. Navision shortcut :

Create a shortcut this way:

“%Program files\NavisionFolder%\fin.exe” servername=%servicename%,nettype=TCP,company=%companyname%

servername = The service that we creates
nettype= TCP (this is standard)
company= The Company name of the account

2. Setup the host file

Open this folder “C:\WINDOWS\system32\drivers\etc\” and edit “hosts”

Add this entry:
IPadress Servicename (ipadress on the server and the servicename)

If it’s a local server use 127.0.0.1

3. Setup the services file

Open this folder “C:\WINDOWS\system32\drivers\etc\” and edit “services”

Add this entry:

%servicename 3001/tcp (Servicename + and a free port/TCP)

4. See if it works

Run this from a CMD

Server.exe NetType=TCP,ServerName=%Servicename%,Cache=1000000,DataBase=%databasefilelocation%

ServerName = The service name
DataBase= The path for the fdb file include the file

Then open the shortcut that is created in 1 then it should open navision.

5. Create the service

Run this from a CMD

Server.exe NetType=TCP,ServerName=%Servicename%,Cache=1000000,DataBase=%databasefilelocation%,installasservice

ServerName = The service name
DataBase= The path for the fdb file include the file

Then the service is created, change it to run thru local system and start it.