which version of SQL

[PaulSh]

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]

Hi @PaulSh 

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

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]

Thanks for your reply

Windows update has SQL 2014 SP3

Shall I install that or not.

[nickypic]

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.