Blog posts > SharePoint 2010 > , , , , , ,
Posted on: November 18, 2009  

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

7

This article describes the installation and configuration of SQL Server 2008 required for deploying SharePoint Server 2010 and is a part of a series describing the complete installation of SharePoint Server 2010 on Windows Server 2008 R2 and SQL Server 2008 R2. Please have a look at

There you can find an overview of the complete series and of course the farm topology and the deployment scenario.

Note: Please read the comment at the end of this post by Wes Preston since he mentions a book describing how to install SQL Server 2008 R2 on the same maschine where you want to install SharePoint 2010. Shortiiik explains in the comments why.

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.
  • Click next at the installation rules.

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

  • 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.

Resources

Here are the resources used in this article:

Next steps

Please take a look at Part 8: SharePoint Server 2010 installation.

Comments

11/19/2009 8:17:49 AM #

SharePoint Kaffeetasse 139

SharePoint 2010 Installation Installing SharePoint Server 2010 on Windows Server 2008 R2 and SQL Server

Michael Greth [SharePoint MVP] Reply

11/29/2009 12:33:41 PM #

نصب تصویری و قدم به قدم شیرپوینت 2010

msdn.microsoft.com/.../ee554869(office.14).aspx www.codeproject.com/.../...ePoint_Server_2010.aspx

مجید رواقی Reply

2/21/2010 12:39:50 PM #

Hi, there!
I'm following this walkthrough, but since I don't have additional computer for Domain Controller, I am trying to install the whole thing on one machine. In this step, the installation of Sql Server 2008 R2, I was warned, being a domain controller might cause problems. However, I continued and bumpued into a problem, where I had to point the installation the Account for the Sql Server Agent Service - it showed me wrong credentials, when I pointed the newly created(from Powershell) Managed Service Accounts! So, I googled alot, and found this:
blogs.technet.com/.../...ged-service-accounts.aspx
I decided to go with the standard NT Authority\System account and then change the running account of the service through the Services Console.
I'll write back if I succeed/fail with this.
Thanks for your posts, Andreas!

Kocko Bulgaria Reply

4/28/2010 10:12:03 PM #

Deploying SharePoint 2010 in a three tier farm and SQL Server 2008 R2 issues

Deploying SharePoint 2010 in a three tier farm and SQL Server 2008 R2 issues

andreas glaser Reply

5/19/2010 12:20:37 AM #

Another tidbit that might belong here or the previous page/step:  There is a sQL Server 2008 R2 ebook that mentions you need to install the SharePoint 2010 bits - WITHOUT running the config - BEFORE installing SQL Server 2008 R2 (assuming they're talking about on the same machine).  There weren't a lot of details, so I'm not sure of which scenarios this applies to yet - we're still checking.  

blogs.msdn.com/.../...soft-sql-server-2008-r2.aspx

Wes Preston United States Reply

5/20/2010 9:19:12 AM #

Hi Wes,

that's interesting... it would be really great if you can share your findings if you figure it out :)

Thanks in advance
Andreas

Andreas Switzerland Reply

5/24/2010 8:20:51 AM #

2Wes Preston: the only information mentioned in the ebook about installing sharepoint BEFORE running SQL Server 2008 R2 installation I found was because of the "analyses integration with sharepoint" option be displayed in the installation wizard. See page 10: "In order to use this new installation feature option, SharePoint 2010 must be installed but not configured prior to installing SQL Server 2008 R2."

So there is no need to install sharepoint before the sql server unless you want to install analyses services that integrated with sharepoint :)

Shortiiik Czech Republic Reply

Add comment





  Country flag
 

biuquote
Loading