mibuso.com
Home› SQL General
Options

SQL 64 bit - is this configuration supported by Microsoft?

frelfrel 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

  • Options
    krikikriki Member, Moderator Posts: 9,096
    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!

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

    Freelance Dynamics AX
    Blog : http://axnmaia.wordpress.com/
  • Options
    DenSterDenSter Member Posts: 8,304
    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
    MVP - Business Apps
  • Options
    krikikriki Member, Moderator Posts: 9,096
    [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.