Issue

Installing and Configuring Second Database Server on Single Machine
Solution

1. Copy the folder for the first Navision Database Server (usually C:\Program Files\Microsoft Business Solutions-Navision\Database Server) and paste to a new location and rename.

2. From a command prompt, change directory to the newly created directory

3. Enter the following command: server installasservice

4. Once the command has completed, there will be a new service registered.
 
5. Open the Navision Application Server Manager Snap-in (NASMSnapIn) (Start > All Programs > Microsoft Business Solutions-Navision > Microsoft Business Solutions-Navision Application Server Manager)

6. Add the Database Server Manager (if not already present).

File > Add Remove Snap-in. which will open the "Add/Remove Snap-in" dialog.
Then select "Add" and select "Navision Database Server Manager" from the "Add Standalone Snap-in" dialog
Then Close the "Add Standalone Snap-in" dialog
Select "OK" from the "Add/Remove Snap-in" dialog
Now the "Navision Database Server Manager" should be visible in the left pane of the NASMSnapIn window

7. Select the Database Server Manager and select Action > New > Navision Database Server Manager from the menu bar. A "New Navision Database Server Manager" input dialog will appear.

8. Enter either localhost or in the Host Name text field and the service name in the Service Name text field and click OK.

9. The new database server should appear under the Navision Database Server Manager in the left pane (you may need to drill down on the Navision Database Server Manager to see it).

10. Select the new database server

11. The right pane should display the current settings of the selected database server.

12. For production environments:

Cache (Kb) = 1000000
Commit Cache = Checked
Server Name = Server Name
Net Type = TCP/IP
Sessions = 0
Database = Full path to database


i. Note: the database server can only connect to a database that is not currently occupied by another server or client

13. Then select "Apply these settings"

14. Next open services: Start > Administrative Tools > Services

15. Find the new service in the list and right click and select Properties

16. Select the Log On tab and set Log on as: to Local System account and press OK.

17. Now you should be able to start the new Navision Database Service.

18. Once the service is started test the service by opening a client and connect to the database server by entering the new database service in the "Open Database" dialog - Database Server field. Make sure to clear the database field.

19. Log on as normal.

20. You should be able to interact with the database and others can also connect to the same database server at the same time.