U4BW Supported Operating System & SQL Server Versions

U4BW – Windows and SQL Server Versions

UNIT4 Business World (Agresso) is now supported on Windows Server 2016 and SQL Server 2016 which can offer enhanced performance, security and high availability features such as SQL Server Availability Groups.

SQL Server High Availability Groups  were first introduced in SQL Server 2012 as an Enterprise Feature. In SQL Server 2016 Standard Edition, Basic Availability Groups are now available.

Basic Availability Groups are a cut-down version of the Enterprise offering. They do however fit quite well with the U4BW setup and can be used to provide a very good High Availability / Disaster Recovery setup for a relatively low cost.

The setup can be:-

  • Both servers on-premise
  • Both servers cloud based
  • Primary server on-premise and secondary server cloud based (Hybrid Cloud)

In each setup there are advantages and disadvantages. But each one offers a great solution compared to a single server.

The following table shows which versions of U4BW are supported on Windows Server 2016 and SQL Server 2016. (Please note, SQL Server 2016 doesn’t need Windows Server 2016 and will run on Windows Server 2012 R2.)

U4BW Version SQL Server 2016 Windows Server 2016
Milestone 5 Yes Requires UPDATE05
Milestone 6 Yes Requires UDPATE03
Milestone 7 Yes Yes

SQL Server 2005 end of Extended Support

Extended support for SQL Server 2005 ends on 12th April 2016. This means that Microsoft will no longer be producing security updates for this product. Not sure how many Agresso customers are still running SQL Server 2005 but imagine there are still a few. We have dealt with other customers recently that still have some SQL Server 2005 instances.
For further details….
SQL Server 2008 and 2008 R2 still have plenty of life left in them with the extended support running until 2019, although mainstream support for them did stop in 2014. However, some software vendors (including UNIT4) have dropped support for 2008 and 2008 R2 for their latest software releases.
For further details….