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





































