SQL 64 bit - is this configuration supported by Microsoft?

frel
frel Member Posts: 2
edited 2007-03-01 in SQL General
I have question about this configuration:

Navision 4.01 latest SP on 32 bit Windows XP connected to SQL 64 bit on Windows 2003 64 bit – is this configuration supported by Microsoft?

I would like to use Windows Integrated logins.
--
No Signature

Comments

  • kriki
    kriki Member, Moderator Posts: 9,121
    frel wrote:
    Navision 4.01 latest SP
    I suppose you mean 4.00SP3?
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • nunomaia
    nunomaia Member Posts: 1,153
    SQL Server 2000 or 2005 ?
    Nuno Maia

    Freelance Dynamics AX
    Blog : http://axnmaia.wordpress.com/
  • DenSter
    DenSter Member Posts: 8,307
    Yes that is supported. Make sure you install the right 64x version of the extended stored procedures. NAV does not recognise those 64x versions though (dll name is hardcoded in the exe), so you have to add them manually. Make sure you add the enumusergroups as well as the enumusersids ESP's, so both security models are supported.

    Also, when you install NAV on the SQL Server, DO NOT do a full install. Make sure you do the custom install, and make sure that you unselect MSDE. For some reason, when you're on 64x, the NAV installer does not recognize SQL Server and it will install MSDE. This will screw up your SQL Server 2005 installation, and can possibly cause the server OS to fail.
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • kriki
    kriki Member, Moderator Posts: 9,121
    [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!

Categories