Installing SQL Server 2008 R2

The SharePoint databases need to reside in a SQL Server implementation. The version of SQL must be either SQL Server 2008 or higher, or SQL Server 2005. The SQL server component can either reside on a separate server or installed on the SharePoint server itself, for smaller, single server deployments.

Note

For testing or development, the Express version of SQL Server can be used, which is included in a standalone installation option of SharePoint. The standalone version of SharePoint and the Express version of SQL are NOT recommended for production environments.

This chapter assumes that the full SQL Server 2008 R2 product will be installed on a single SharePoint all-in-one server. Installation steps are subsequently ...

Get Microsoft SharePoint 2010 Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.