Login failed when connecting to SQL (RTC)

smishra
smishra Member Posts: 28
in NAV Three Tier
Hi All,

We have 3 tier architecture (NAV2009 R2-RTC)
Classic client working fine for all user’s.
RTC working fine - in NAV SERVER (where Nav server installed)
but when I am connecting through RTC in the user’s system then I faced this error-screenshot attached.

Can u suggest what things I skipped or any other things required.

Thanks6bvr120mhk8y.png

Answers

  • bbrown
    bbrown Member Posts: 3,268
    Configure delegation
    There are no bugs - only undocumented features.
  • jordi79
    jordi79 Member Posts: 285
    Can you use ADMINISTRATOR login (the one in NAV ServeR) to login via user's system?

    If you can, then this is a SQL user permission.

    Add the local user as a user via SQL Server Management studio, and assign rights. (or add a group and assign users to that group)

    Jordi
  • smishra
    smishra Member Posts: 28
    Hi bbrown,
    I have open the Active directory (with service account user ),Dynamics NAV server running through service account and we select a delegation TAB tvvyjofs0thp.png

    which setting we are missing, please suggest ?


  • bbrown
    bbrown Member Posts: 3,268
    Unfortunately it has been a long time since working with NAV 2009 and I don't really recall the specifics of this process. You should be able to Google for "NAV 2009 delegation" (or similar) and find several guides. That's what I would need to do.
    There are no bugs - only undocumented features.
  • jordi79
    jordi79 Member Posts: 285
    Hi Smishra,
    Not the active directory. SQL Management Studio.
    rb8db0dbwncr.png
    Try to create the user here, and assign that same user to the NAV database via User mapping.
    p5jfyyk9ifsm.png

  • smishra
    smishra Member Posts: 28
    Hi Jordi,
    can you please explain in more details so that I can resolve this issue?
    Thanks
  • bbrown
    bbrown Member Posts: 3,268
    https://help.sana-commerce.com/sana-commerce-93/installation/prepare-nav-environment/nav-2009-threetier-environment?msclkid=31539753ac6011ecb60231a5b008f25f

    This may help you. Yes, this is an Active Directory configuration.
    There are no bugs - only undocumented features.

Categories