GetCompaniesList error configuring Outlook Sync to use Web Services

GetCompaniesList error configuring Outlook Sync to use Web Services

  • Comments 5

In NAV 2009, Outlook Synchronization includes the option to use the new Web Services functionality instead of using C/FRONT and NAS. This is great and demonstrates some of the functionality that Web Services has to offer.

One issue that can arise when setting this up in a “3 machine” environment is when configuring the Microsoft Office Outlook Add-In. When selecting a company, you could receive an error similar to one of the following.

The connection to "" Microsoft Dynamics NAV database failed. The program returned the following error: GetCompaniesList error: The login failed when connecting to SQL Server xxx. connection string: NavSynchronizationUrl=http://yyy:7047/DynamicsNAV/WS/Codeunit/DynamicsNAVsynchOutlook;CompanyName=zzz; Please verify your synchronization settings. If the problem persists contact your system administrator.

The connection to "" Microsoft Dynamics NAV database failed. The program returned the following error:GetCompaniesList error: The request failed with HTTP status 401: Unauthorized. connection string: NavSynchronizationUrl=http://yyy:7047/DynamicsNAV/WS/Codeunit/DynamicsNAVsynchOutlook;CompanyName=zzz; Please verify your synchronization settings. If the problem persists contact your system administrator.

Note xxx is the server name of the SQL Server (Database Tier), yyy is the server name of the Dynamics NAV Server (Service Tier), and zzz is the company name.

These errors can occur if NAV Web Services are not setup with the correct SPNs and delegation information. If you haven’t already, make sure your have reviewed the walkthrough on setting up a 3 machine install (found in the nav_install.chm help file, NAV Help can be downloaded here.) and the previous post about setting up NAV 2009 Web Services.

Scott Wright (scowri )
Microsoft Dynamics NA

Microsoft Customer Service and Support (CSS) North America

Leave a Comment
  • Please add 5 and 4 and type the answer here:
  • Post
  • Hi there, I am configuring outlook integration for a client, NAV 2009 SP1 Classic Client (no RTC). I have not been able to find anywhere a list of pros/cons for using web services over NAS. Are you able to assist?

  • Hello David,

    I'll be glad to assist! You are correct, there isn't any list of advantages/disadvantages between using web services (WS) over a NAS with using Outlook Integration.

    I spoke with our Outlook Integration guru on using WS over NAS and this is what he came up with.

    1. Easier to setup (This is dependent on already having the 3-tier configuration setup.)

    2. Frees up your one NAS user license for another function.

    3. The NAS will not be in NAV "7". Since the NAS is basically a "headless" client, it will be removed along with Forms, the Native database, and the Classic client.

    Hope this information helps!

    Scott Wright | Senior Technical Support Engineer | Microsoft Dynamics NAV NA Support Team

  • Thanks a lot for that Scott, we shall go with Web Services it is the way of the future :)

    I am actually getting the issues listed in this article now, however I am not using 3 separate machines. I have the SQL Server and NAV Server on the same machine, yet I am getting the "HTTP Status 401" permissions error.

    Both NAV Server and NAV Webservices services are being run with the same domain account, which has admin rights. If its the same machine, is any of the delegation stuff relevant? Could it have anything to do with IIS?

    Thanks

    Dave

  • Hello Dave,

    Thank you for the update! Glad to hear you'll be using Web Services. :-)

    Delegation/authentication setup shouldn't be needed in a two machine setup, but since you're using domain account instead of Network Service account there is some additional setup needed for the Object Change Listener.

    The following link explains the scenarios that need additional setup and what needs to be done.

    Enabling the Object Change Listener

    http://msdn.microsoft.com/en-us/library/dd568739(v=NAV.60).aspx

    If setting up the Object Change Listener doesn't resolve the issue, I would recommend opening a support incident as we'll need to get additional information and possibly take a look at the environment.

    To answer you last question, no I would expect this to be related to IIS since we don't directly use IIS.

    Thanks,

    Scott Wright | Senior Technical Support Engineer | Microsoft Dynamics NAV NA Support Team

  • Thanks Scott. Still having dramas. I will log through the official channels. If you're interested, I have also put it up on mibuso.

    http://www.mibuso.com/forum/viewtopic.php?f=32&t=41375

Page 1 of 1 (5 items)