---
title: Create A Dynamics NAV 2013 To 2018 – SQL Server Data Source With Jet Reports
description: "## Overview   Learn how to create a Dynamics NAV 2013 to 2018-SQL server data source with jet reports. We can create a data source type for **Dynamics NAV 2013 to 2018 (SQL Server)** in Jet Reports. ![](https://globaldata365.com/wp-content/uploads/2023/06/image-20.png) ## Creating a…"
url: "https://globaldata365.com/helpcenter/create-a-dynamics-nav-2013-to-2018-sql-server-data-source-with-jet-reports/"
updated: "2026-07-01"
category: Jet Reports
tags:
  - jet reports
---

# Create A Dynamics NAV 2013 To 2018 – SQL Server Data Source With Jet Reports

## Overview

 

Learn how to create a Dynamics NAV 2013 to 2018-SQL server data source with jet reports. We can create a data source type for **Dynamics NAV 2013 to 2018 (SQL Server)** in Jet Reports.

![](https://globaldata365.com/wp-content/uploads/2023/06/image-20.png)

## Creating a Jet Reports Connection to the NAV SQL Database

 

**1)** Inside Excel, navigate to the Jet ribbon and open your **Data Source Settings**.

![create-a-dynamics-nav-2013-to-2018-sql-server-data-source-with-jet-reports](https://globaldata365.com/wp-content/uploads/2023/06/image-21.png)

**2)** Click **Add** on the *Data Source Setting*s tool bar.

 

Provide your data source a unique and descriptive name within the *Add Data Source* dialog box. Choose **Dynamics NAV 2013-2018** as the *Database Type* and **Direct SQL Server** from the *Connection Method* pull-down list.

 

Click the **Add** button.

![create-a-dynamics-nav-2013-to-2018-sql-server-data-source-with-jet-reports](https://globaldata365.com/wp-content/uploads/2023/06/image-26.png)

 

**3)** On the *Authentication* tab...

 

![create-a-dynamics-nav-2013-to-2018-sql-server-data-source-with-jet-reports](https://globaldata365.com/wp-content/uploads/2023/06/121-1024x449.png)

 

If your SQL Server is configured to automatically recognize the user names used to log on to Windows, you can use one of the "Windows Authentication" options (either the current Windows user or another Windows user).

 

 **Looking to simplify financial reporting in Excel?**
[👉 Join our Jet Reports Training](https://globaldata365.com/jet-reports-training-austin-tx/) and learn to create real-time, dynamic reports with confidence.

 

If your SQL Server is not configured to recognize Windows user names, you will need to choose **SQL Server Authentication** and provide the user name and password for an account that does have permissions to access the SQL Server.  Please contact your system administrator to determine what information should be used.

 

Once you have specified how to access the SQL database, you will then want to specify which NAV user will be used when determining the roles and permissions used to access the NAV data.  If your NAV system is configured to recognize the usernames used to log on to Windows, you can choose to use the current Windows users.  Otherwise, Jet Reports also supports the use of **NAV User Password authentication**.

 

**4)** On the *Connections* tab...

 

You will need to provide the name or IP address of the SQL server where your NAV database resides. Select the specific BC database you want to use, and then select the company within that NAV database that you want to use by default (even if there is only one). The drop-down will show the names of available Databases and Companies in their respective options.

 

![create-a-dynamics-nav-2013-to-2018-sql-server-data-source-with-jet-reports](https://globaldata365.com/wp-content/uploads/2023/06/121-1-1024x449.png)

 

**5)** Click **Test Connection** to test your connection to the database.

![create-a-dynamics-nav-2013-to-2018-sql-server-data-source-with-jet-reports](https://globaldata365.com/wp-content/uploads/2023/06/image-27.png)

**6)** If you want your NAV 2013-2018 data source to be your primary data source, click **Set as Default**.

![](https://globaldata365.com/wp-content/uploads/2023/06/image-28.png)

**7)** Click **OK** and your new Dynamics NAV 2013 to 2018 data source is ready to be used in Jet Reports.

 

#### If You Need Any Help, [Contact Us](https://globaldata365.com/contact/) Now!

[wpforms id="13267"]