Configuring Database Components

Use Microsoft Dynamics NAV 2016 Setup to install SQL Server Database Components. This is software you install on the computer running the SQL Server database to manage interaction between Microsoft Dynamics NAV and the SQL Server database.

You can install database components on the same computer as Microsoft Dynamics NAV Server (as described in Walkthrough: Installing the Three Tiers On Two Computers) or on a separate computer (as described in Walkthrough: Installing the Three Tiers on Three Computers). SQL Server Database Components are a default component for the Developer Option in Microsoft Dynamics NAV 2016 Setup, but for a production environment you can select SQL Server Database Components either by customizing the Server Option or by performing a complete custom installation (that is, by choosing Custom on the Choose an installation option pane in Setup). For more information, see How to: Choose Components to Install.

When you select SQL Server Database Components in Setup you must also decide whether to install the second-level component, which is the Microsoft Dynamics NAV Demo database.

Configuring Database Components in Setup

If you select SQL Server Database Components in Setup you have the option of configuring related settings on the Specify parameters pane. These settings are in a section entitled SQL Server Database Components.

Settings

The following parameters pertain to database components.

Parameter Description

SQL Server instance

Specifies the instance of SQL Server to which Microsoft Dynamics NAV Server attempts to connect. The default value is NAVDEMO, which Microsoft Dynamics NAV creates. This differs from earlier versions of Microsoft Dynamics NAV, which installed the Demo database to the default SQL Server instance.

SQL Database

Specifies the name of the database that Microsoft Dynamics NAV interacts with.

The default value specifies the Demo database: Demo Database NAV (9-0).

This option is only present in Setup when you include the Demo database.

Replace Existing Database

Specifies what Setup should do if the Demo database is already present in the specified SQL Server instance.

With the default value (No), Setup completes with an error.

With this parameter set to Yes, Setup completes with no error.

This option is only present in Setup when you include the Demo database.

See Also

Tasks

How to: Deploy a Microsoft Dynamics NAV Database to Azure SQL Database

Concepts

Configuring Microsoft Dynamics NAV
Configuring Microsoft SQL Server