Hi,

I am getting below error while creating new Web Application in SharePoint.

Could not connect to Sharepoint using integrated security: SQL server at has an unsupported version 10.0.2531.0.

I am using SharePoint Foundation 2010. SQL Server Version is "Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64)   Mar 29 2009 10:11:52   Copyright (c) 1988-2008 Microsoft Corporation  Developer Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: ) (VM)"

My SQLServer version is Microsoft SQL Server 2008 (SP1) Developer edition. How could i resolve this issue.

Thanks & Regards

Poomani Sankaran

Hi

Dev version isn't supported

Check official Software requirements

https://technet.microsoft.com/en-us/library/cc288751%28v=office.14%29.aspx

Hi Poomani,

Upgrade to SQL Server 2008 R2 Developer Edition and it will work with SharePoint Foundation 2010. Ensure that you only use this developer edition on your development server.

SQL Server 2008 R2 Developer Edition has same code base and same features which are available in SQL Server 2008 R2 Enterprise Edition. Only difference between them is licensing terms. Developer Edition can not be used in production environment and it can be used on development server only.

Romeo,

I have seen some articles that, They specified like, SQL Server "Developer Edition" would support in SharePoint which can be used for Development environment.

It could not be used in production since it would leads to license issues.

Thanks & Regards

Poomani Sankaran

Yes you are absolutely right. SQL Server Developer Edition supports SharePoint Foundation but should only be used for SharePoint development environment. SQL Server Enterprise/Standard editions are meant for production environment.

Hi Zakir,

Thank you.

If so then why am i getting the above error in my environment while create Web Application.

My Server : Window Server 2012 R2.

SharePoint Foundation 2010

Microsoft SQL Server 2008(SP1) "Developer Edition".

It is frustrating me. :(

Regards

Poomani Sankaran

• Edited by Poomani Sankaran 1 hour 1 minutes ago Spell Mistake

Hi Poomani,

Only SQL Server 2008 SP1 will not do the job. You must also install Cumulative Update 2 on your SQL Server to make it compatible with SharePoint Foundation 2010.

If this also doesn't work then refer to my previous answer and upgrade to SQL Server 2008 R2 Developer Edition.

Hi Zakir,

How could i download and install Cumulative Update 2 for SQL Server 2008 SP1 ?

Could you please take me in the right direction?

I have tried one which leads to failure.

Regards

Poomani Sankaran

Hi Poonami,

Here you go Cumulative Update Package 2 for SQL Server 2008 Service Pack 1

Hi Zakir,

As i said. i have downloaded the Hotfix from here only but getting error. I have downloaded zip and extracted like below image.

Getting the error like below.

TITLE: SQL Server Setup failure.
------------------------------

SQL Server Setup has encountered the following error:


A failure was detected for a previous installation, patch, or repair during configuration for features [SQL_BooksOnline_Redist,]. In order to apply this patch package (KB970315), you must resolve any issues with the previous operation that failed. View the summary.txt log to determine why the previous operation failed.

Error code 0x84B20001.

------------------------------
BUTTONS:

OK
------------------------------

• Edited by Poomani Sankaran 21 hours 44 minutes ago added info

Hi Zakir,

Thank you.

If so then why am i getting the above error in my environment while create Web Application.

My Server : Window Server 2012 R2.

SharePoint Foundation 2010

Microsoft SQL Server 2008(SP1) "Developer Edition".

It is frustrating me. :(

Regards

Poomani Sankaran

• Edited by Poomani Sankaran Thursday, April 16, 2015 6:34 AM Spell Mistake

Hi,

Based on the error "Could not connect to Sharepoint using integrated security: SQL server at has an unsupported version 10.0.2531.0.", it is related to the SQL version, you need to install update pack to upgrade sql version.

More information, please check:

SharePoint 2010 SQL Server has an unsupported version 10.0.2531.0

About the error occurs during the installation of the update pack, I suggest you can create a new thread in sql forum, you will get more information from there.

Sql Forum

Thanks

Best Regards