Sunday, January 16, 2011

SQL server at xxx has an unsupported version 10.0.2531.0, SharePoint PSConfig error

While I was preparing a bonsai SharePoint 2010 web farm with Sql Server 2008 Enterprise database in my Dell Studio 1555. As I did numerous standalone SharePoint 2010 deployment for development activity on Windows Server 2008/R2/Win 7 with Sql Server 2008 express + SP1, I used to have the pre-requisites handy in my hard disk to build multiple virtual hard disks.
After building and networked the domain controller and the enterprise database server, executed the SharePoint 2010 installer and ran the PSConfig wizard on designated app server image. While connecting to the database server, wizard throws an error
---------------------------
SharePoint Products Configuration Wizard
---------------------------
SQL server at windb\dbsvr2010 has an unsupported version 10.0.2531.0. Please refer to "http://go.microsoft.com/fwlink/?LinkId=165761" for information on the minimum required SQL Server versions and how to download them.
---------------------------
OK   
---------------------------
I never expected this behavior ,went back to my standalone SharePoint installation and verified the database server. It says 10.0.2531.0 and running happily.
Went back to MSDN Hardware and Software requirement, there's a different standard for Sql Server 2008 Express(standalone) and Sql Server 2008 Enterprise(Farm installation). 
If you are gonna install Sql Server Express 2008 as your data store you are good enough to go with only Sql Server SP 1 (10.0.2531.0) but if you are preparing a web farm and proceeding for Non-Express database then you should also install the Cumulative update 2(10.0.2714) or CU5 (Installing CU3 or CU4 is not recommended)
Now the PSConfig wizard is happy and configures my web farm successfully.

No comments: