NAV 4 SP1 compatible with Windows Server 2008/SQL Server2008

ajmalsherif
ajmalsherif Member Posts: 111
edited 2008-10-29 in SQL General
Hi

i am considering a migration and would like to know if this is possible for above - any opinions appreciated

thanks

Ajmal

Comments

  • kine
    kine Member Posts: 12,562
    Because NAV 4.00SP1 is not fully compatible with SQL 2005, it is not fully compatible with SQL 2008...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • David_Singleton
    David_Singleton Member Posts: 5,479
    Also to be honest, 4.00 SP1 is a really horrible version of NAV. Just go to SP3 executables, its much much better. And switch to Standard Security model.
    David Singleton
  • ajmalsherif
    ajmalsherif Member Posts: 111
    Will the code units for SP2 and SP3 be a straightforward import or could their be potential conflicts with bespoke development?
    Sorry what is Standard Security model?

    Will going to SP3 make it compatible with SQL 2005 (and SQL 2008?)
  • David_Singleton
    David_Singleton Member Posts: 5,479
    ajmalsherif wrote:
    Will the code units for SP2 and SP3 be a straightforward import or could their be potential conflicts with bespoke development?
    Sorry what is Standard Security model?

    Will going to SP3 make it compatible with SQL 2005 (and SQL 2008?)

    Simple does not exist in SP1, but basically it means you will no longer need to run the "Synchronize security routine"

    I have not seen any conflicts with SP1 objects on SP3, but note that there are some "issues" in SP1 that are not resolved simply by an executable upgrade.

    Yes the sp3 executables are SQL 2008 compatible, but make sure you have the correct hotfixes.

    Make sure to read Waldo's blog before you switch excutables.
    David Singleton
  • ajmalsherif
    ajmalsherif Member Posts: 111
    In my ignorance #-o i am continuing with an install of V4 Sp1 on 64 bit platform

    I have immediately hit a snag 'The SQL Server ODBC driver on your computer is not a recent version' - Is this becasue i need a 64-bit version of MDAC, and if so where can i get it from?

    Also can any one point me to a document which lists all the fixes for v4 SP1 to SP3?

    THANKS
  • David_Singleton
    David_Singleton Member Posts: 5,479
    David Singleton wrote:
    Make sure to read Waldo's blog before you switch excutables.


    Platform updates overview - 3.70.B - NAV2009 CTP4 - Waldo's Blog Microsoft Dynamics NAV
    David Singleton

Categories