-->![Microsoft Dynamics Nav 2009 Odbc Driver Microsoft Dynamics Nav 2009 Odbc Driver](/uploads/1/2/6/3/126348843/264423678.png)
Use Microsoft Dynamics NAV 2018 Setup to install SQL Server Database Components. This is software you install on the computer running the SQL Server database to manage interaction between Dynamics NAV and the SQL Server database.
2 Select Microsoft Dynamics NAV 5.0 ODBC. 3 Click the Change button to change your installation of the Dynamics NAV ODBC Driver, or click the Remove button to remove the driver from your system. Windows Installer will repair or remove th e Dynamics NAV ODBC Driver automatically, depending on your choice. You cannot disable a parameter dialog box in an N/ODBC query by options in Microsoft Dynamics NAV 2009. Content provided by Microsoft. Assume that you have a parameter in an N/ODBC query in Microsoft Dynamics NAV 2009. The parameter is dynamic and is specified when you run the query. Replace the files in the Microsoft Dynamics NAV ODBC.
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 2018 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 Dynamics NAV Demo database.
![Microsoft Dynamics Nav 2009 Odbc Driver Microsoft Dynamics Nav 2009 Odbc Driver](/uploads/1/2/6/3/126348843/264423678.png)
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 Dynamics NAV creates. This differs from earlier versions of Dynamics NAV, which installed the Demo database to the default SQL Server instance. |
SQL Database | Specifies the name of the database that Dynamics NAV interacts with. The default value specifies the Demo database: Demo Database NAV (10-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
Configuring Microsoft Dynamics NAV
Configuring Microsoft SQL Server
How to: Deploy a Microsoft Dynamics NAV Database to Azure SQL Database
Configuring Microsoft SQL Server
How to: Deploy a Microsoft Dynamics NAV Database to Azure SQL Database