Solved

cannot install sharepoint with sql express

Posted on 2015-01-30
7
50 Views
Last Modified: 2016-11-23
Hi
I am trying to demo sharepoint.
I have installed SQL Express 2008 on a Win Server 2008 box. All installed fine and have the express version with SP1. I have set the neccessary rights in SQL for the sharepoint AD accounts that were created (dbcreatror, security admin).
I have installed Sharepoint 2013 onto the same box. On the configuration wizard, when I try connect set up a new server farm, at the point where i specify configuration database settings, i receive the message:

"SQL server at ****\sqlexpress has an unsupported version 10.0.1600.22."

Will this work with SQL Express?
0
Comment
Question by:MongolianNoseFlute
7 Comments
 
LVL 44

Accepted Solution

by:
Rainer Jeschor earned 250 total points
ID: 40581161
Hi,
no this will not work.
SharePoint requires at least any 64-bit edition of SQL Server 2008 R2 SP 1 or higher.
From MSDN:

Minimum requirements for a database server in a farm:
One of the following:
The 64-bit edition of Microsoft SQL Server 2012.
The 64-bit edition of SQL Server 2008 R2 Service Pack 1
https://technet.microsoft.com/en-us/library/cc262485%28v=office.15%29.aspx#section4

And secondly - the version number you posted seems to be SQL 2008 RTM (so without service pack).
HTH
Rainer
0
 
LVL 80

Assisted Solution

by:David Johnson, CD, MVP
David Johnson, CD, MVP earned 250 total points
ID: 40581298
SharePoint databases must be Latin1_General_CI_AS_KS_WS and you can use the 64bit sql express and you need sql database 2008R2 at minimum.
0
 

Author Comment

by:MongolianNoseFlute
ID: 40583492
thanks for the repies guys but they are both conflicting, David are you saying it will work with express?
0
Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

 
LVL 44

Expert Comment

by:Rainer Jeschor
ID: 40583499
Hi,
no, they are not conflicting. You need at least SQL 2008 R2 (not 2008) in 64bit edition (either Express, Standard ...). David just additionally mentioned the required collation.
HTH
Rainer
0
 

Author Comment

by:MongolianNoseFlute
ID: 40583897
ah - sorry about that!! checking this all out now, thanks guys!
0
 
LVL 17

Expert Comment

by:GreatGerm
ID: 41898817
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There is one common problem that all we SharePoint developers share: custom solution deployment. This topic can't be covered fully in this short article, so all I want to do in this one is to review it from a development-to-operations perspectiv…
SharePoint Designer 2010 has tools and commands to do everything that can be done with web parts in the browser, and then some – except uploading a web part straight into a page that is edited in SPD. So, can it be done? Scenario For a recent pr…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

756 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question