Forum Discussion

PaulSh's avatar
PaulSh
Experienced User
6 years ago
Solved

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

Thanks

 

 

  • nickypic's avatar
    nickypic
    6 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.

     

     

3 Replies

Replies have been turned off for this discussion
  • nickypic's avatar
    nickypic
    Former Staff
    6 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
    6 years ago

    Thanks for your reply

    Windows update has SQL 2014 SP3

    Shall I install that or not.

     

  • nickypic's avatar
    nickypic
    Former Staff
    6 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.

     

     

FAQs

Australian Tax FAQ's (DESKTOP + ONLINE)

Hello everyone!  We've collated a list of frequently asked questions users have posted on the Forum for your convenience. Check them out below! GENERAL What do I need to do before starting a ne...

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.