Nav 5.0 SP1 u2 + SQL 2008 R2 | but what SQL service pack level?

Business Central/NAV Technical Forum
1

Hello,

Regarding to SQL Server 2008 R2 and SQL servicepacks;
What SQL servicepack level is supported for Nav 5.0 SP1 u2?

I found the following information online but no details about the servicepack level:

www.mibuso.com/…/viewtopic.php
We support the following versions of Microsoft Dynamics NAV with Microsoft SQL Server 2008 R2:

  • Microsoft Dynamics NAV 2009 SP1
  • Microsoft Dynamics NAV 5.0 SP1 with Update 2

This is the case:
The NAV implenting company did install the SQL 2008 R2 (standard) server and applied all Microsoft Updates offered online.
So SQL 2008 R2 SP1, which is offered thru Microsoft Update, is the current installed SQL SP level.

Unfortunately SP2 will never be offered through Microsoft Update so the NAV SQL company says therefore SP2 will not be installed because it’s not offered this way.

My guess is that’s this ‘logic’ is a bit unfortunate to miss out on this servicepack only not to be offered thru Microsoft Update. My guess is that it’s done because of the need of an attended setup, not because it’s not recommended by Microsoft.

So is there any official documentation on the SP levels? and further, post SP cumulative updates … sorry for asking but what about them?

Thanks,
Arian van der Pijl!

2

From Nav 2009 onwards there is a folder named Prerequisite Components which is useful.

3

HI Arian,

I would go a head and install it to a test server to be 100% sure that there are no issues. I don’t think there would be. But just to be sure. Microsoft have never communicated anything officially about their support of NAV 5.0 SP1 and SQL Server 2008 R2 SP2. But neither have I seen any issues reported on it.

4

Actually they have: It requires update 2

https://mbs.microsoft.com/customersource/documentation/systemrequirements/msdynav_sqlserver2008r2.htm?printpage=false&sid=whie4i4pjqtlh3ro0tyspxz5&stext=SQL 2008 R2

5

Thank you but unfortunately this is Nav5.0

6

Thanks for this reply, unfortunately I cannot access that page.

Could you please provide me with an excerpt / copy of that page (if legally allowed)?

Hopefully it explicitly states SP2 of SQL 2008 R2 or any Servicepack available.

7

Well the link only states that SQL Server 2008 R2 requires NAV 5.0 SP1 Update 2. It does not mention anything about the SQL 2008 R2 service pack levels supported.

8

To all,

Thanks for all the replies.
Unfortunately no explicit SQL SP level ‘requirements’ for Nav 5.0 SP1 u2.
Guess you might translate that to the full SQL 2008 R2 product with all SP’s applied.

Guess that will do for now!

Best regards,

Arian van der Pijl!