Forum Discussion

PaulSh's avatar
PaulSh
Experienced User
5 years ago

which version of SQL

We have MYOB classic and the new AO ver 2019.1 v 5.4.32.108 Can you advise what version of SQL we should have on our server and any service pack. Not sure if it should be SQL 2012 or SQL 2014 Than...
nickypic's avatar
nickypic
Former Staff
5 years ago

Hi PaulSh 

 

You can find out system requirements on our website - https://www.myob.com/au/support/accountants-and-bookkeepers/resources/minimum-system-requirements?_ga=2.43220519.325959866.1580874220-241142401.1580874220

 

I've reviewed this for you and there is a note - 

** For MYOB AO sites integrating to AO Classic, Microsoft SQL Express 2008 R2 32 bit is supported on versions prior to 2017.2.  For later versions SQL 2014 Express 32 bit is supported which will be supplied in the MYOB product installs.  Other versions of SQL are not supported with MYOB AO.

 

SQL2014 Express is provided as part of the MYOB AO Full install download.  When installing MYOBAO this will be automatically installed and configured for use with MYOB AO.  

 

If migrating from another server please refer our migration notes - http://help.myob.com/wiki/x/aQZ3AQ

  • PaulSh's avatar
    PaulSh
    Experienced User
    5 years ago

    Thanks for your reply

    Windows update has SQL 2014 SP3

    Shall I install that or not.

     

    • nickypic's avatar
      nickypic
      Former Staff
      5 years ago

      Hi PaulSh 

       

      I wouldn't preinstall SQL.  

       

      I suggest running the MYOBAO full install and this will automatically install the correct version of SQL for you.

       

       

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.