Install SharePoint 2010

Installing SharePoint Server 2010 on Windows Server 2008 R2 and SQL Server 2008 R2 - Part 7: SQL Server 2008 R2 installation and configuration

This guide shows you how to install and configure SQL Server 2012. The configuration includes assigning permissions and configuring networking.

SQL Server 2008 installation

The installation of SQL Server 2008 compared to SQL Server 2008 R2 is almost the same and described below.

If you get a compatibility warning while trying to install SQL Server 2008 on Windows Server 2008 R2 you can proceed with install.

Before running SQL Server you need to apply Service Pack 1.

You need to apply Service Pack 1 to SQL Server 2008 if running on Windows Server 2008 R2.

SQL Server 2008 R2 installation

If you haven’t done yet  install .NET Framework 3.5 SP1.

On the left side click “Installation” and on the right side click "New installation or add features to an existing installation".

Install .NET Framework 3.5 SP1 before installing SQL Server 2008. Select New installation or add features to an existing installation.

Install the setup support files.

Skip setup support rules. Installation of setup support files.

Select “SQL Server Feature Installation”.

Skip setup support rules again. Select a new SQL Server 2008 installation.

Select the “Database Engine Services” feature and the “Management Tools - Basic” feature. Check additional features if needed.

Select the Database Engine Services feature and the Management Tools Basic feature. Click next to skip the installation rules.

Check additional features if needed.

Keep the default instance and default folders.

Keep the default instance and default folders an proceed to the next screen. Verfiy installation settings.

Use the same account for the services and select the sqlSvcAcc you created in Active Directory.

Keep the collation settings you can see in the screenshot.

Select a service account for SQL Server 2008 services. Keep the collation settings.

Add the SharePoint 2010 setup administrator user as a “SQL Server Administrator”.

Add the SharePoint 2010 setup administrator user as a SQL Server Administrator. Skip the error reporting dialog.

Click next at the “Installation Configuration” Rules screen.

Skip the installation configuration rules screen. Verify your SQL Server 2008 installation settings.

Start the installation of SQL Server 2008 R2.

Start SQL Server 2008 R2 installation. The SQL Server 2008 R2 installation was successful.

SQL Server 2008 R2 configuration

There are 2 configuration steps you need to do: assign permission to the SharePoint 2010 setup administrator and configure networking.

Assign permission

The SharePoint 2010 setup administrator needs to have the securityadmin and dbcreator role. The sysadmin role is assigned if you decide during SQL Server 2008 installation that your SharePoint 2010 setup administrator should be the SQL admin.

I decided to do so in my Hyper-V development environment.

The SharePoint 2010 setup administrator needs to have the securityadmin and dbcreator role.

Configure networking

At the end you need to configure networking if you are planning to deploy a farm with multiple SharePoint Server 2010 servers.

According to TechNet [1] you need to “ensure that SQL Server 2005 or SQL Server 2008 is updated to the required level and configured as follows”:

  • SQL Server 2005: Local and remote connections are enabled and are configured to use the TCP/IP protocol.
  • SQL Server 2008: The TCP/IP protocol is enabled for the network configuration.
    RTM: TechNet still says (May 6, 2010) you need TCP/IP but you don’t need Named Pipes. From my experience you need Named Pipes.

Configure networking in SQL Server 2008.

Difference to SharePoint 2007

In SharePoint 2007 you needed to configure named pipes which isn’t necessary in SharePoint 2010.

This Article

  •  SQL Server Installation & Configuration
 

Next Steps

Resources

Here are the resources used in this article:

blog comments powered by Disqus