questions regard navision 5.0 in regards to the SQL database

qqtofuqqtofu Member Posts: 49
edited 2008-02-11 in SQL General
Hello there

got a question regarding Does navision 5.0 support a 64 bit SQL environment?

another question is does implementation of the Navision 5.0 require mixed mode authentication or windows authentication?


thanks!

Comments

  • ara3nara3n Member Posts: 9,256
    Yes Navision supports sql 64 bit. In fact we recommend 64 bit.

    Navision supports Mixed mod. In fact we recommend mixed mode authentication.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • qqtofuqqtofu Member Posts: 49
    ara3n wrote:
    Yes Navision supports sql 64 bit. In fact we recommend 64 bit.

    Navision supports Mixed mod. In fact we recommend mixed mode authentication.

    question regarding why the recommendation for the 64 bit and the mixed mode authentication, the reason behind?


    thanks!
  • kinekine Member Posts: 12,562
    64bit - better peformance an 32bit will not be supported on servers in next years

    mixed mode - because sometime you need to use database logins to authenticate into NAV...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • bbrownbbrown Member Posts: 3,268
    Even if you plan to have only "Windows Authenticated" users, set up mixed mode and create at least one DB Login (SUPER).

    If your Windows domain fails you can still get into Navision.

    If the Navision DB is moved off your network domain it will be accessible.
    There are no bugs - only undocumented features.
  • ara3nara3n Member Posts: 9,256
    Also Consultants that need to connect to the but are not on the network can only use database authentication.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • krikikriki Member, Moderator Posts: 9,115
    [Topic moved from Navision forum to SQL General forum]
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


Sign In or Register to comment.