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 .

After enetering database server details I get following error:




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  ( ) 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  ( ) 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 .

MOSS 2007 Allowing anonymous users to upload to document library

By default SharePoint server doesn't allow anonymous users to upload items to document library.

If you try to set permissions on document library for anonymous users like you used to do on custom lists you will see that add, edit and delete items options are grayed out.


This can be issue for public facing WCM sites where you want to allow anonymous useres to post or attach some documents, and you want to store those attachments in your document library.


Best way to solve this is by calling  SPSecurity.RunWithElevatedPrivileges.

What this method does is changing context from anonymous to the context in which app pool runs, giving you full permissions.

If you try to execute code from context of anonymous user without calling this method you will get Security exception and user will be redirected and prompted for user name and password

Here is the example:




   26  SPSite siteCurrent = SPContext.Current.Site;

   27  SPWeb webCurrent = SPContext.Current.Web;


   29  SPSecurity.RunWithElevatedPrivileges(delegate()

   30  {

   31    using (SPSite elevatedSite = new SPSite(siteCurrent.ID))

   32    {

   33      using (SPWeb elevatedWeb = elevatedSite.OpenWeb(webCurrent.ID))

   34      {

   35          elevatedWeb.AllowUnsafeUpdates = true;

   36          SPList SPCandidateList =


   37          SPCandidateList.AnonymousPermMask64 =

                       SPBasePermissions.ViewListItems |

   38                  SPBasePermissions.OpenItems |

   39                  SPBasePermissions.Open |

   40                  SPBasePermissions.ViewFormPages |

   41                  SPBasePermissions.AddListItems;


   43           // Code for adding items to your list


It's important that you create instance of your "elevated" SPWeb and SPSite inside SPSecurity.RunWithElevatedPrivilages method call.

After uploading item to document library you will notice that value of "Modifed by" column is "System Account"

showing in which context item was added.


About me

Bizic Bojan is Co-Founder of Amida IT-Services GmbH and Software Architect with focus on .NET, C++, Python and Cloud Native solutions. 



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.