Troubleshooting the Dynamics NAV Web Service Data Source

Complete text of error message is:

The url 'http://[servername:port]/[NAV Server Instance]/WS/SystemService' is not valid.  The following error was reported:

The remote server returned an error: (503) Server Unavailable.

Troubleshooting:

Applicable to NAV 2013 Web Service

Using the Dynamics NAV Administration Console, validate that the NAV Server Instance (shown in the error message) is running.

1. Locate the correct NAV Instance
   1. If not running, restart
2. Troubleshoot the code Units.  Check the codeunit, validate multiple codeunits that are published:
   1. Unpublish all codeunits and pages
   2. Republish just the Jet Codeunit and retest the connection

Complete text of error message is:

Invoking the web service failed with the following message:

Unable to connect to the remote server.

Troubleshooting:

Applicable to NAV 2015 (and higher) Web Service

Using the Dynamics NAV Administration Console, validate that the NAV Server Instance (shown in the error message) is running.

1. Locate the correct NAV Instance
   1. If not running, restart
2. Follow the steps for troubleshooting codeunits as listed in error #1

Complete text of error message is:

The url 'http://[servername:port]/[NAV Server Instance]/WS/SystemService' is not valid.  The following error was reported:

The remote name could not be resolved: 'servername'

Troubleshooting:

In the Jet Excel add-in...

1. Access the Data Source Settings
2. Go to the Web Services tab
   1. Verify that the name entered for the server is correct
   2. If not, correct it and then re-test

Complete text of error message is:

The url 'http://[servername:port]/[NAV Server Instance]/WS/SystemService' is not valid.  The following error was reported:

The remote server returned an error: (404) Not Found.

Troubleshooting:

In the Jet Excel add-in...

1. Access the Data Source Settings
2. Go to the Web Services tab
   1. Verify that the name entered for the instance is correct
   2. If not, correct it and then re-test

Complete text of error message is:

The url 'http://[servername:port]/[NAV Server Instance]/WS/SystemService' is not valid.  The following error was reported:

Unable to connect to the remote server.

Troubleshooting:

1. Verify that the port number listed in the error is correct and also matches what is shown in the Dynamics NAV Administration Console.
2. Using the Dynamics NAV Development Environment, verify that the server name you are using in your Jet Data Source Settings is correct (File|Database|Information). 

Complete text of error message is:

The url 'http://[servername:port]/[NAV Server Instance]/WS/ CRONUS%20USA,%20Inc/Codeunit/Jet_Data_Source' is not valid.  The following error was reported:

The remote server returned an error: (500) Internal Server Error.

Troubleshooting:

Use the Development Environment's Object Designer to confirm that the Jet Codeunits are installed and are of the correct version for the version of the Jet Excel add-in you are using:

Complete text of error message is:

The Dynamics NAV web service is improperly configured.  A web service server and instance name must be specified and the port number must be between 1 and 65535 .

Troubleshooting:

In the Jet Excel add-in...

1. Access the Data Source Settings
2. Go to the Web Services tab
   1. Verify that the Instance field is populated with the correct information.

Complete text of error message is:

Company '' does not exist.

Troubleshooting:

In the Jet Excel add-in...

1. Access the Data Source Settings
2. Go to the Web Services tab
   1. Verify that the correct Company can be selected from the drop-down list
   2. If able to do so, select that company and re-test the connection

Complete text of error message is:

The codeunit '' does not exist.

Troubleshooting:

In the Jet Excel add-in...

1. Access the Data Source Settings
2. Go to the Web Services tab
   1. Verify that Codeunit Jet_Data_Source can be selected from the drop-down list
   2. If able to, select Jet_Data_Source
      (note: typing in the name of the codeunit will result in an error... it must be selected from the list)
   3. Select the correct Company from the drop-down list
   4. Save the settings and re-test the connection

Complete text of error message is:

The url 'http://[servername:port]/[NAV Server Instance]/WS/SystemService' is not valid.  The following error was reported:

The underlying connection was closed:  An unexpected error occurred on a send.

Troubleshooting:

1. Access the Data Source Settings
2. Go to the Web Services tab
   1. Check whether or not Use SSL encryption is enabled or disabled
3. Access the Dynamics NAV Administration Console
4. Open the SOAP Services section for the specific NAV Service Instance being used
   1. Check whether or not Enable SSL is checked.
   
   The settings MUST match

Complete text of error message is:

The url 'http://[servername:port]/[NAV Server Instance]/WS/SystemService' is not valid.  The following error was reported:

The remote server returned an error: (401) Unauthorized.

Troubleshooting:

1. Ensure you are using one of the following five types of Dynameics NAV authentication supported by Jet Reports:
   1. Windows Authentication
   2. User Name Authentication
   3. NAV User Password Authentication
   4. Access Control Service Authentication
   5. Office 365 Authentication (also known as OAuth authentication)
   For detailed information for each authentication type, please see NAV 2015 Authentication Types
2. Check if user is a user in NAV
3. Try using IP Address instead of Server name
4. Ensure that the user is able to get the NAV.xml file to open by entering the server URL (shown in the error message) in Internet Explorer's address bar.
   
   

Complete text of error message is:

A server was not found at "net.tcp://[servername:port]/[NAV Server Instance]/Service".  Either the URL is incorrect or the server is currently not available.

Troubleshooting:

Issue encountered when attempting to connect to NAV 2013 R2 (or higher) RoleTailored Client (RTC).

1. Confirm that the server shown in the error message is correct
2. In the ‘Services.msc’ Management Console, confirm that SQL Server{SQLversion} and SQL Server Agent {SQLversion} are both ‘Started’
3. In the Dynamics NAV Administration Tool, confirm that the status of the NAV Server Instance is ‘running’
   
   1. Unpublish all codeunits and pages
   2. Republish just the Jet Codeunit and retest the connection

Complete text of error message is:

Cannot interpret data as a URL .

Troubleshooting:

If Client Services port setting is incorrect, above error will occur.

To located the necessary information:

1. Access the NAV RTC 
2. Click the blue drop-down arrow: 
3. Click Select Server...

1. Access the Data Source Settings
2. Go to the Drilldown tab
3. Configure the RTC folder for the location where your RTC is installed
4. Configure the RTC Server, Client Service Port, and RTC Instance from the information you gathered from within NAV: