SQL Server Database Components

  • Article

SQL Server database components configure Microsoft SQL Server to work with Microsoft Dynamics NAV 2018.

If SQL Server is not present on the computer where you install the database components, then Setup automatically installs SQL Server Express 2016, which you can use for prototyping, developing, and testing. We recommend that you use SQL Server 2016 or SQL Server 2014 in production environments.

If you are installing the CRONUS International Ltd. demonstration database, Setup will automatically install SQL Server Express 2016 if it does not find an existing NAVDEMO instance in SQL Server. So if you intend to install the CRONUS database to an existing SQL Server installation, remember to create a NAVDEMO instance in SQL Server before you run Dynamics NAV Setup.

In Dynamics NAV Setup, SQL Server database components are a default component for the Developer Option. You can add the components to the Server Option or as part of a custom installation.

When you have installed the Dynamics NAV SQL Server database components on a database server, you can create new Dynamics NAV databases in the Dynamics NAVdevelopment environment, by using the development environment commands, or by using the Dynamics NAV Windows PowerShell cmdlets.

See Also

Developer Option
Custom Option
Configuring Database Components
Microsoft Dynamics NAV Windows PowerShell Cmdlets
Development Environment Commands