cannot install sharepoint with sql express

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?
MongolianNoseFluteAsked:
Who is Participating?
 
Rainer JeschorConnect With a Mentor Commented:
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
 
David Johnson, CD, MVPConnect With a Mentor OwnerCommented:
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
 
MongolianNoseFluteAuthor Commented:
thanks for the repies guys but they are both conflicting, David are you saying it will work with express?
0
2018 Annual Membership Survey

Here at Experts Exchange, we strive to give members the best experience. Help us improve the site by taking this survey today! (Bonus: Be entered to win a great tech prize for participating!)

 
Rainer JeschorCommented:
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
 
MongolianNoseFluteAuthor Commented:
ah - sorry about that!! checking this all out now, thanks guys!
0
 
GreatGermCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
All Courses

From novice to tech pro — start learning today.