For accessing Dynamics NAV 2013 or newer, Jet Basics includes multiple connection methods:
Let's look at how to establish a Direct SQL Server connection to your database
For organizations and users with direct access to the SQL Server on which their NAV database is stored (and using Windows Authentication or NAV User/Password Authentication), this data source can provide substantially faster reporting access than is traditionally possible through NAV's Web Services.
If your organization uses a different type of connection, please see one of our other articles:
(although these articles describe the full Jet Reports Excel add-in, the concepts also apply to Jet Basics)
Once you have selected Direct SQL Server and clicked OK, the first thing you must do is specify the account information that will be used to connect directly to the SQL Server
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).
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 user names used to log on to Windows, you can choose Windows Authentication (current user) to use the current Windows user's credentials. Otherwise, Jet Basics also supports the use of NAV User Password authentication (see information about NAV Authentication types)
You will need to provide the name or IP address of the SQL Server hosting your NAV database.
Once this information is provided, you can click the Database down arrow to select the name of your NAV database
Next, click the Company down arrow to select the NAV company name (this must be specified even if you have only one company in your NAV database).
Test the Connection
After you have completed these steps, you can click the Test Connection button at the top of the window to ensure that all settings are correct.