This Post is part of  SharePoint 2010 Installation Series

This topic is only for installing sql server with power pivot if you have no plans for applying power pivot services you should skip this step and proceed to the next step

SQL Server Installation Without Power Pivot

This topic is not working it ended up with some error at the end and the power pivot wasnt working … Still looking through it

• 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 Analysis Services with SharePoint Integration option and then select New Farm from the drop down menu.

  

  • Click Next , Next, Next
  • On the New SharePoint Farm Configuration, enter YOUR username and password or the account you are using to configure your server, specify a passphrase that meets the standard password requirements, for example ‘Password1′, and leave the default port number or enter a port number of your choice.do-

  
  

  • Click 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 select Latin1_General From the Drop down for both the Database Engine and Analysis Services

  

  • 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
  • On the Analysis Services configuration page, click Add Current User to ensure that your account has access to Analysis Services
  • Click "Add.." and add the user "Fo-Dev-07-SP-Farm"

    

  • Click Next , Next

  

  • Next and Install

  

  For more information please visit this link

This Post is part of  SharePoint 2010 Installation Series

1. Run the SharePoint Server 2010 Installation
2. Select Install Software Prerequisites
3. Press Next , Check I accept and Install

1. After that select "Install SharePoint Server"
2. Enter The Product Key and click continue
3. Accept Agreements and click Next
4. Select Server Farm

1. Select Complete and Click Install Now

1. It is very important to un check The box Run the sharepoint wizard and click close

This Post is part of  SharePoint 2010 Installation Series

Accounts list

It is strongly recommended to create domain accounts and use them as service accounts.

For more information see this topic

You need to create at least the following accounts in Active Directory

My current naming scheme is Computer Name-Product – User Role

In my case i am using one account the farm admin account (Fo-Dev-07-SP-Farm )for all

The sharepoint services.

But you should create for every service a separate service account in order to meet least-privilege security best practice.

You should give a service account only the permissions needed by the service to work properly. E.g. the content access account only needs read permissions. Using the SharePoint Farm Account which is member of the farm administrators group as the content access account isn’t the thing I would do

Create Accounts

Steps to add users

1. Click Start , Administrative Tools , Active Directory Users And Computers
2. Select the folder you want to add user in and right click it add new user
3. Enter User Details , Click Next
4. Enter password And Uncheck User Must Change Password
5. Check User Cannot Change Password and Password Never Expires

1. Click Next and Finish
2. Repeat the same process for all the users

Assign Permissions

Setup administrator( Fo-Dev-07-SP-Admin )

1. You need to put the setup Admin account has to be a member of the administrators group on every server SharePoint should be installed
   1. Select Start , Administrative Tools , Computer Management
   2. Under System Tools – Local Users and Groups
   3. Right Click Administrators – Properties
   4. Click Add enter Setup Admin account (Fo-Dev-07-SP-Admin(
   5. Repeat the same steps for each server in the farm
2. The same above steps should be done to the account Fo-Dev-07-SP-Farm
3. Setup Admin account must be assign the following roles in the sql server : dbcreator and securityadmin. ( will configure that in the SQL Server Installation Step Later in this series )

Farm account ( Fo-Dev-07-SP-Farm )

The farm account is used for the following things :

1. "Configure and manage the server farm."
2. "Act as the application pool identity for the SharePoint Central Administration Web site."
3. "Run the Microsoft SharePoint Foundation Workflow Timer Service."
4. In my case i am using the same account for the SharePoint services.

SQL Server service account ( Fo-Dev-07-SQL-Services )

You don’t need to assign permissions since they are assigned during installation of SQL Server 2008.

The SQL Server service account is used to run SQL Server and should be a domain account.

This Post is part of SharePoint 2010 Installation Series

1. Click Start, point to Administrative Tools, and then click Server Manager.
2. In the features Tab Select Add Features
   
3. Select SMTP Server and Add Required Role Services

1. Click Next Next Install
2. After Click Start, point to Administrative Tools, and then click (IIS) 6.0 Manager
3. Right click [SMTP Virtual Server #1] and choose properties
4. Select Access Tab and then click Relay
5. Click add
   1. IP address : 127.0.0.1 , click ok

This Post is part of  SharePoint 2010 Installation Series

On the Initial configuration task windows,

1. Click "Add Roles"
2. Check the check box for "Application Server".
3. The wizard opens a modal dialog Just click the "Add Required Features" button
4. Check the check box for "Web Server (IIS)"

1. Click Next twice to go "Role Services"
2. NET Framework 3.5 SP1 is selected by default. Check all the role services as shown in the picture and add all required features.

1. Click Next twice to go "Role Services"
2. Make check the boxes to be like the following images

1. Click Next and Then Install

Pop3, SMTP, Outlook

Since Windows Server 2008 the Pop3 server feature is deprecated. If you need mail you have to install Exchange Server or something similar.

This Post is part of  SharePoint 2010 Installation Series

I started By installing the Hot Fix

• Hot Fix for Windows Server 2008 SP2
• Hot Fix for Windows Server 2008 R2

Should be pretty basic download and install right a way

IE Enhanced Security Configuration

Don’t do this in production environment! If you are deploying SharePoint 2010 in a development environment you can disable Internet Explorer Enhanced Security configuration if you want to open Central Administration and other SharePoint 2010 sites directly on the server.

Use the server manager to disable enhanced security for users and administrators.

1. Click Start, point to Administrative Tools, and then click Server Manager.
   
2. If the User Account Control dialog box appears, confirm that the action it displays is what you want, and then click Continue.
   
3. Under Security Summary, click Configure IE ESC

1. Under Administrators, click On (Recommended) or Off, depending on your desired configuration.
   
2. Under Users, click On (Recommended) or Off, depending on your desired configuration.
   
3. Click OK.

1. Restart Internet Explorer to apply Enhanced Security Configuration.

The remaining software requirements can be installed by using the SharePoint Products and Technologies 2010 Preparation Tool.

• Microsoft "Geneva" Framework
  
• Microsoft Sync Framework v1.0
  
• Microsoft Filter Pack 2.0
  
• Microsoft Chart Controls for Microsoft .NET Framework 3.5
  
• Windows Power Shell 2.0 CTP3
  
• Microsoft SQL Server 2008 Native Client
  
• Microsoft SQL Server 2008 Analysis Services ADOMD.NET
  
• Microsoft Silver light 3
  
• ADO.NET Data Services v1.5 CTP2 for Windows Server 2008 SP2
  
• ADO.NET Data Services v1.5 CTP2 for Windows Server 2008 R2
  
• SQL Server 2008 R2 November CTP Reporting Services Add-in for Microsoft SharePoint Technologies 2010

Visual Studio 2010

After wards i choose to install Visual Studio 2010 first, i recommend you

To start by doing that if you are making a developer environment to avoid

Sql server 2008 problems between the server version and the version that comes with Visual studio 2010

This Post is part of SharePoint 2010 Installation Series

Windows Server 2008

Your operation system needs to meet the following requirements:

• Windows Server 2008 SP2 64-bit
  
• Windows Server 2008 R2 64-bit
  
• SQL Server 2008 R2 November CTP
  
• Hot Fix
  for Windows Server 2008 SP2
  
• Hot Fix
  for Windows Server 2008 R2
  
• Visual Studio 2010 ( Developer Environment )

The remaining software requirements can be installed by using the SharePoint Products and Technologies 2010 Preparation Tool.

• Microsoft "Geneva" Framework
  
• Microsoft Sync Framework v1.0
  
• Microsoft Filter Pack 2.0
  
• Microsoft Chart Controls for Microsoft .NET Framework 3.5
  
• Windows Power Shell 2.0 CTP3
  
• Microsoft SQL Server 2008 Native Client
  
• Microsoft SQL Server 2008 Analysis Services ADOMD.NET
  
• Microsoft Silver light 3
  
• ADO.NET Data Services v1.5 CTP2 for Windows Server 2008 SP2
  
• ADO.NET Data Services v1.5 CTP2 for Windows Server 2008 R2
  
• SQL Server 2008 R2 November CTP Reporting Services Add-in for Microsoft SharePoint Technologies 2010
  
  

This Post is Part of SharePoint 2010 Installation Series

• Processor
  64-bit, dual processor, 3 GHz
  
• RAM
  4 GB for stand-alone or evaluation installation and 8 GB for single server and multiple server farm installation for production use
  
• Hard disk
  80 GB

  This is my current server settings and it has 50 GB hard disk memory

  

  Other things to know

The list above is meant for informational purposes only. The official list of system requirements for SharePoint 2010 is located at http://technet.microsoft.com/en-us/library/cc262485(office.14).aspx and includes additional details on prerequisites and other optional components.

References links

http://technet.microsoft.com/en-us/library/cc262485(office.14).aspx

http://blogs.msdn.com/sharepoint/archive/2010/01/22/operating-system-requirements-of-sharepoint-2010.aspx