SharePoint Products >
SharePoint 2010 Forums
>
SharePoint 2010 - General Questions and Answers
>
Will SQL Server 2008 Enterprise edition work for sharepoint 2010 server installation instead of SQL Server 2008 express edition?
Will SQL Server 2008 Enterprise edition work for sharepoint 2010 server installation instead of SQL Server 2008 express edition?
- Will SQL Server 2008 Enterprise edition work for sharepoint 2010 server installation instead of SQL Server 2008 express edition?
Answers
- As long as it is running x64, yes:
http://blogs.msdn.com/sharepoint/archive/2009/05/07/announcing-sharepoint-server-2010-preliminary-system-requirements.aspx
You would need to do a "server farm" install if you want to choose your database server as standalone uses a new, local SQL instance.- Proposed As Answer byWes PrestonMVPTuesday, November 24, 2009 2:54 PM
- Marked As Answer byMike Walsh MVPMVPThursday, November 26, 2009 7:07 AM
All Replies
- Will SQL server 2008 enterprise edition work for sharepoint 2010 server instead of SQL server 2008 express edition?
- Merged byMike Walsh MVPMVPTuesday, November 24, 2009 7:02 AMsame question; same poster; both have replies
- As long as it is running x64, yes:
http://blogs.msdn.com/sharepoint/archive/2009/05/07/announcing-sharepoint-server-2010-preliminary-system-requirements.aspx
You would need to do a "server farm" install if you want to choose your database server as standalone uses a new, local SQL instance.- Proposed As Answer byWes PrestonMVPTuesday, November 24, 2009 2:54 PM
- Marked As Answer byMike Walsh MVPMVPThursday, November 26, 2009 7:07 AM
- Yes.(and there was a previous thread asking about SQL Server 2008 Standard Edition that got the same answer)Make sure you use Advanced Installation / Full to make sure you actually use your full SQL Server 2008.P.S. NEVER post the same question twice. I'm merging this with the other copy as both have replies.
FAQ sites: (SP 2010) http://wssv4faq.mindsharp.com; (v3) http://wssv3faq.mindsharp.com and (WSS 2.0) http://wssv2faq.mindsharp.com
Complete Book Lists (incl. foreign language) on each site. - > As long as it is running x64,Not strictly true.Microsoft has said that they will only support 64-bit SQL Server 2008 with SPS 2010, but SharePoint Server 2010 will also work with 32-bit SQL Server 2008 (on a separate server to SPS 2010).
FAQ sites: (SP 2010) http://wssv4faq.mindsharp.com; (v3) http://wssv3faq.mindsharp.com and (WSS 2.0) http://wssv2faq.mindsharp.com
Complete Book Lists (incl. foreign language) on each site. - Interesting. I wonder if any checks will be put in place in later versions to block the 32-bit SQL Server from working. I certainly wouldn't recommend 32-bit SQL for 2010 OR 2007.
- >I wonder if any checks will be put in place in later versions to block the 32-bit SQL Server from working.
As far as I know that won't be the case (but then I'm not an insider).
I can't however see the point of such a block. There will be Microsoft customers who want to use - perhaps temporarilly - existing servers running 32-bit SQL Server nnnn. Maybe even only to test SPS 2010. So there seems no point in actively blocking this use - recommending 64-bit as they do now is another matter.
FAQ sites: (SP 2010) http://wssv4faq.mindsharp.com; (v3) http://wssv3faq.mindsharp.com and (WSS 2.0) http://wssv2faq.mindsharp.com
Complete Book Lists (incl. foreign language) on each site. - And also ia64 - that is also supported:)
- I just did this install yesterday so I know this works:
1. Install 64-bit version of SQL Server 2008 Enterprise Edition
2. Install SQL Server 2008 Service Pack 1
3. You will need to apply the cumulative update 2 or greater. (Sharepoint will give you an error during install if you don't have this. I used cumulative update 2 even though 4 is available because that is what the error message wanted. )
- Proposed As Answer byPaminCambridge Wednesday, December 16, 2009 5:18 PM