While working today on a customers site installing SharePoint 2010 i discovered that i could not connect to create a database using the SharePoint configuration wizard, after digging into SQL with Chris we discovered that the hosting company where using an unpatched version of SQL 2008 which required many updates.
So for the sake of my own sanity and yours i thought i would write this post and include a chart showing all the SQL 2008 versions also links to the patches that you will need. I hope it helps and i will endevour to keep it updated.
| Patch Level | Build | Version Number |
| 2008 + Cumulative Update 7 for SP1 | 2,766 | 10.00.2766 |
| 2008 + Q978839 | 2,760 | 10.00.2760 |
| 2008 SP1+Q978791 | 2,758 | 10.00.2758 |
| 2008 + Cumulative Update 6 for SP1 | 2,757 | 10.00.2757 |
| 2008 + Cumulative Update 5 for SP1 | 2,746 | 10.00.2746 |
| 2008 + Cumulative Update 4 for SP1 | 2,734 | 10.00.2734 |
| 2008 + Cumulative Update 3 for SP1 | 2,723 | 10.00.2723 |
| 2008 + Cumulative Update 2 for SP1 | 2,714 | 10.00.2714 |
| 2008 + Q970507 | 2,712 | 10.00.2712 |
| 2008 + Cumulative Update 1 for SP1 | 2,710 | 10.00.2710 |
| 2008 + Service Pack 1 | 2,531 | 10.00.2531 |
| 2008 + Cumulative Update 10 | 1,835 | 10.00.1835 |
| 2008 + Cumulative Update 9 | 1,828 | 10.00.1828 |
| 2008 + Cumulative Update 8 | 1,823 | 10.00.1823 |
| 2008 + Cumulative Update 6 | 1,812 | 10.00.1812 |
| 2008 + Cumulative Update 5 | 1,806 | 9.00.1806 |
| 2008 + Cumulative Update 4 | 1,798 | 10.00.1798 |
| 2008 + Cumulative Update 3 | 1,787 | 10.00.1787 |
| 2008+Q958186 (Available by request.) | 1,779 | 10.00.1779 |
| 2008+Q958611 | 1,771 | 10.00.1771 |
| 2008+Q956718 | 1,750 | 10.00.1750 |
| 2008 RTM | 1,600 | 10.00.1600.22 |
| 2008 February CTP | 1,300 | 10.00.1300.13 |
| 2008 July CTP (requires Virtual Server 2005 R2) | 1,049 | 10.00.1049.14 |
| 2008 June CTP | 1,019 | 10.00.1019.17 |
Related posts:
- PowerShell ISE in Server 2008 R2 With SharePoint Modules Some of you may have noticed that the ISE environment...
- SharePoint 2010 with a virtual SQL 2008 database. Will it perform? Many people have many different opinions on this subject. Is...
- SharePoint and Server 2008 R2 (Better Together) A while ago I did a post on adding icons...
- SharePoint 2010 Topologies Part 2 To continue this series, in this post I will...
- DHCP Server 2008 R2 One of the issues we have been seeing in...
- Blocking Windows Update KB976002 Last week I did a short post called Windows Update...
3 comments
2 pings
Alex Billing says:
May 4, 2010 at 3:19 pm (UTC 0 )
If, like me, your sharepoint farm is based on SQL 2005, then the minimum requirement for Sharepoint 2010 is SQL 2005 Service Pack 3 with Cumulative Update 3 applied. Useful information if you haven’t made the move to SQL 2008 yet.
Dave Coleman says:
May 4, 2010 at 3:41 pm (UTC 0 )
Thanks good info
TomPier says:
May 8, 2010 at 8:18 pm (UTC 0 )
great post as usual!
Tweets that mention SQL 2008 Version Numbers and Patch Levels « Chris and Dave's SharePoint And Tech Blog -- Topsy.com says:
April 29, 2010 at 2:59 pm (UTC 0 )
[...] This post was mentioned on Twitter by Planet SharePoint, Dave Coleman. Dave Coleman said: New Post SQL 2008 Version Numbers and Patch Levels http://bit.ly/dxCgfv -> Hope it helps [...]
Chris and Daves SharePoint and Tech Blog » Hardware and software requirements for SharePoint 2010 says:
July 17, 2010 at 11:54 am (UTC 0 )
[...] Patch levels for Microsoft SQL server 2008 and links can be found in this post [...]