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:
- 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/ .