SharePoint 2010 – SQL Server has an unsupported version 10.0.2531.0

After installing SharePoint2010 on clean Windows Server 2008 R2 machine

I ran sharepoint products configuration wizzard and first thing wizzard asked was to

specify database configuration settings.  Before installing SharePoint2010 I installed latest version of SQL Server Express Edition

with advanced services from Microsoft download section

http://www.microsoft.com/downloads/details.aspx?FamilyID=b5d1b8c3-fda5-4508-b0d0-1311d670e336&displaylang=en .

After enetering database server details I get following error:

 

alt

 

After searching for fix on microsoft site I found that

SharePoint Server 2010 requires a 64-bit edition of SQL Server. The minimum required SQL Server versions are as follows:

  • SQL Server 2008 Express Edition Service Pack 1, version number 10.0.2531
    For more information, visit the following Microsoft Web site:
    http://www.microsoft.com/downloads/details.aspx?FamilyID=01af61e6-2f63-4291-bcad-fd500f6027ff (http://www.microsoft.com/downloads/details.aspx?FamilyID=01af61e6-2f63-4291-bcad-fd500f6027ff)
  • SQL Server 2005 Service Pack 3 cumulative update package 3, version number 9.00.4220.00
    For more information, click the following article number to view the article in the Microsoft Knowledge Base:
    967909  (http://support.microsoft.com/kb/967909/ ) Cumulative update package 3 for SQL Server 2005 Service Pack 3
  • SQL Server 2008 Service Pack 1 cumulative update package 2, version number 10.00.2714.00
    For more information, click the following article number to view the article in the Microsoft Knowledge Base:
    970315  (http://support.microsoft.com/kb/970315/ ) Cumulative update package 2 for SQL Server 2008 Service Pack 1

 

So basically it says 'Your version of SQL Server is obsolete, download latest version'.

Solution : SQL SERVER 2008 R2 Express 

To avoid requesting cumultive updates for your current installation of SQL Server best way at this point of time

to download new version of Sql express.

SQL Server 2008 R2 Express http://www.microsoft.com/express/database/ .

About me

Bizic Bojan is Freelance Software Development Consultant with focus on C++, Qt and .NET based software solutions development. 

 

Disclaimer:

The opinions expressed herein are my own personal opinions and do not represent my employer’s view in any way.

Creative Commons License
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 3.0 Unported License.