Options

Intermittent connection with NAV 2009 R2

engsiong75engsiong75 Member Posts: 143
edited 2014-03-07 in NAV Three Tier
Hi

I am having a problem in a customer's site. They are on NAV 2009 R2. Periodically they would have problem connecting to Navision. The error message is "The login failed when connecting to the SQL Server [Name of Database server]"

The users will then reboot both the SQL server and NAV server. Then the system will be fine.

The application server is on one server. The database server is on another. I have already done the trusting and the SPN setting for the NAV 2009 R2 server.

I also have the same NAV 2013 R2 running on the same server but using a different port. The NAV 2013 database is residing in the same server but on a different instance.

My question is what can be causing this problem. I have already ruled out the DNS server. (They added another server from an old domain in recently and the Navision failed. But the error message is related to the change listener not like the intermittent error.)

The best part of the story is that the NAV 2013 is running fine.

Thank you,

Comments

  • Options
    engsiong75engsiong75 Member Posts: 143
    I have some break through on this issue.

    I found that whenever there was this error on the client machine, the database server will produce an information that "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Reason: Could not find a login matching the name provided."

    I found that the SQL services was starting with the defaulted NT Authority login so I switched it to the domain administrator.

    The intermittent problems still persists inspite of the change. However, I cannot find any thing Navision related using the NT AUTHORITY\ANONYMOUS LOGON to start any service or perform any function.
  • Options
    vremeni4vremeni4 Member Posts: 323
    Hi,

    Could you confirm what ports are used by NAV 2009 R2
    and what ports are used by NAV 2013.
    If it is the same port 7046 that would explain the problem.

    It would be also good to doable check what ports are used by the two instances of the SQL server.
    Is SQL Browser running ?

    Are there any error message in the SQL Server Log ?

    I hope this helps.
  • Options
    engsiong75engsiong75 Member Posts: 143
    Hi

    Could you confirm what ports are used by NAV 2009 R2
    and what ports are used by NAV 2013.
    Reply: NAV 2009 R2 is using 7146. NAV 2013 is using 70XX. I made sure that there are no conflict with the ports when I installed it.

    Are there any error message in the SQL Server Log ?
    Reply: Will check it.

    Thanks
  • Options
    engsiong75engsiong75 Member Posts: 143
    Hi

    There is no error surfacing in the SQL server error log.

    Thank you,
Sign In or Register to comment.