This Post is part of  SharePoint 2010 Installation Series

This topic is only for installing sql server without power pivot if you have already

Installed SQL server with power pivot by following the last step , you should skip this step and the next step SharePoint Configuration Wizard and proceed directly to the step

SQL Server Configuration

• Login as a server and domain controller administrator

If you installed visual studio 2010 before this step you will need to do the following

Create a .reg file and add this lines:

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\.NETFramewor\v2.0.50727\AssemblyFoldersEx\Chart Controls]

@="C:\\Program Files (x86)\\Microsoft Chart Controls\\Assemblies"

And then run the reg file

• Run SQL Server Setup with administrator permissions. Right-click Setup.exe, and select Run as Administrator.
  • Click Installation on the navigation pane to the left.
  • Click New SQL Server standalone installation or add features to an existing installation.
  • In Setup Support Rules, click OK if no problems were detected. Otherwise, follow the instructions on the page to correct the problems and then restart setup.
  • Accept Agreement and Click Next
  • On the Setup Role page, select the Sql Server Feature Installation

  

  • In Feature Selection, Select the following features

    

  • Click Next, Next, Next
  • On the server configuration Click "Use the same account for all SQL Server Services"

    And enter the settings for the user DEVSOLAR\Fo-Dev-07-SQLService

  

  • Click the Collation Tab and click Customize and selecet Latin1_General From the Drop down for the Database Engine

  
  

  • Click Ok , and Next
  • Database Engine Configuration dialog. Click on Add Current User to ensure that you are a SQL Server system administrator.
  • Click "Add.." and add the user "Fo-Dev-07-SP-Farm"

  

  • Click Next , to the end of the wizard and install the server