← Main Project Page

Before you begin

• Ensure all applicable service accounts exist and you know the password to each. For the list of service accounts see Service Accounts in the design document.
• Ensure that all SharePoint Servers' Active Directory Object Accounts (Computer Account) are enabled for "Trust for Delegation to any service (Kerberos)"
• Ensure that SPNs for all applicable service accounts have been properly created. Refer to this document for instructions: Kerberos

Installing Database Servers

• Install SQL Server 2008, keep in mind:
  • Slipstream Service packs and Cumulative Updates
  • Insance features: Database Engine Services (all), Analysis & Reporting Services, BI Development Studio, Management Tools (Basic/Complete), MS Sync Framework.
  • Install, but don't configure, Reporting Services during setup.
• Ensure the SharePoint Setup Service Account (SP10_Setup) has a login on database servers and permissions in accordance with the Permissions Chart.
• Follow the guide: Setting SQL Aliases

Installing SharePoint

Prepare SharePoint Servers

1. Setup the Inclusion list for low file types Instructions.

Using AutoSPInstaller

no instructions yet

Using the GUI

Note: Ensure you are logged in as SP10_Setup account. Do not run Install or SharePoint Configuration Wizard under your own username! Note: Ensure that SQL Connection Alias has been setup on this client. If not, complete this first. See SQL Alias Settings for Clients for more information. Run setup and select Install software prerequisites and accept the license to install. Install Hotfix KB976394: Information - Download Install update KB 982307 for ADO.NET Data Services: KB982307. Includes Old Update: KB976127 - Reference Install KB979917 for ASP.NET: Download Run setup again and select Install SharePoint Server Use Beta key: PKXTJ-DCM9D-6MM3V-G86P8-MJ8CY Select Server Farm Installation In Server Type Select Complete radio button. In File Location tab, change the first box to D: instead of C: and change second box to D:\Search Press OK to start the installation. Once the installation is complete, UNCHECK SharePoint Products Configuration Wizard. We will run the wizard after all SharePoint servers have software installed. Repeat these steps for all other SharePoint Servers in the Farm.

Prepare the Database

Next, we'll prepare the database. This includes adding the appropriate logins and pre-creating a few databases.

Add SharePoint Logins

1. Using SQL Server Management Studio on any SharePoint SQL Server, expand the Logins tree.
2. Right-click and selet New Login...
3. Add SP10_Setup as a user. Also, under Server Roles select both dbcreator and securityadmin
4. Do the same for the Farm Service account, SP10_Farm
5. Repeat steps 3 and 4 for other SQL Servers in the Farm. You can do so from the same Management Studio by clicking File-->Connect Object Explorer and entering the name of the next database.

Pre-create Admin Databases

Follow the TechNet Guide on pre-creating databases. Information When typing the information below, ensure proper spelling and capitalization are used.

1. Create a database named SharePoint_Config which will be the Configuration Database.
2. Ensure the database owner (dbo) is set to SP10_Setup. Ensure the collation is set to LATIN1_General_CI_AS_KS_WS. This is IMPORTANT!! Also ensure that the database is stored on the D:\ drive and logs are stored on L:\ drive.

   

   

3. Create another database named SharePoint_AdminContent with the same database owner (SP10_Setup) and collation (LATIN1_General_CI_AS_KS_WS)

Next, we'll login to our Central Administration Host (CA Host) server. This is an application server that will host the Central Administration website (APP01 Server).

1. Login to the CA Host using the SharePoint Setup User Service Account (SP10_Setup).
2. As Administrator, start the SharePoint 2010 Management Shell (Under Start, All Programs, SharePoint). Remember to Run As Administrator (you will get errors if you don't).
3. Execute the following command to create the configuration database:

New-SPConfigurationDatabase –DatabaseName "SharePoint_Config" –DatabaseServer "SP10Admin1" –AdministrationContentDatabaseName "SharePoint_AdminContent" –Passphrase (ConvertTo-SecureString "Sh@r3F@rm" –AsPlaintext –Force) –FarmCredentials (Get-Credential)

1. You will be prompted for credentials, use DOMAIN\SP10_Farm as the username; the command will take a few minutes to create the database tables.
2. Once completed, move on to

SharePoint Configuration Wizard (First App Server)

It is very important to correctly identify the server which will host the Central Administration Web Application.

Method 1: Preferred

Use SharePoint 2010 Management Shell (Run as Administrator) while logged in as SP10_Setup.

New-SPCentralAdministration -Port 13370 -WindowsAuthProvider "Kerberos"

Method 2: GUI

1. Click Start, All Programs, SharePoint, SharePoint Products Configuration Wizard.
2. Once the wizard starts, press OK to allow it to stop services.
3. The wizard will detect that we've pre-created the configuration database. Verify that the values are correct and press Next.
4. Configure Central Admin Web Application:
   1. Port: 8888
   2. Security: Negotiate (Kerberos)
   3. Accept the warning and continue.
5. Check the following on the summary screen:
   1. Database Server is using an alias, not the actual database server.
   2. Port in Central Administration URL is 8888
   3. Authentication Provider is Negotiate (Kerberos)
   4. Press Next.
6. The wizard will go through about 9-10 steps, monitor for errors.

Once complete, a browser window will open with the Central Administration and the Initial Farm Configuration Wizard. Do NOT run this wizard, just press Cancel and close the browser window for now.

Configure (Admin) Search Service

The following steps will configure the SharePoint Foundation Search. In SharePoint Server 2010, this service is only used to search online Help. Therefore, we will run this service on the same server as the CA Host.

Add SQL Logins

Back in SQL Server Management Studio, we'll now add the SharePoint Server Search Service Account (SP10_Search), the Default Content Access Account (SP10_Crawl) and the services account (SP10_Apps) to SQL groups.

1. SharePoint_Config: Expand the tree for SharePoint_Config, expand Security and expand Users. Add SP10_Search, SP10_Crawl and SP10_Apps. Verify SP10_Farm exists, if not, add it too.
2. SharePoint_Config: Expand the tree for SharePoint_Config, expand Security, expand Roles, and expand Database Roles. Right-click WSS_Content_Application_Pools and select properties. Add SP10_Search, SP10_Crawl and SP10_Apps. Verify SP10_Farm exists, if not, add it too.

1. SharePoint_AdminContent: Expand the tree for SharePoint_AdminContent, expand Security and expand Users. Add SP10_Search, SP10_Crawl and SP10_Apps. Verify SP10_Farm exists, if not, add it too.
2. SharePoint_AdminContent: Expand the tree for SharePoint_AdminContent, expand Security, expand Roles, and expand Database Roles. Right-click WSS_Content_Application_Pools and select properties. Add SP10_Search, SP10_Crawl and SP10_Apps. Verify SP10_Farm exists, if not, add it too.

Verification Switch back to the CA Host. Click Start, All Programs, SharePoint Products 2010, Central Administration and allow the web page to load. Do not configure anything yet. If the page loads properly, move on to the next step. Otherwise, troubleshoot any errors before continuing.

Configure SharePoint Foundation Search

Since the CA Host will also be our SharePoint Foundation Search server, we can configure that now.

1. On the CA Host, open Central Administration. Click Manage Services on Server under System Settings and locate SharePoint Foundation Search.
2. Click on the link SharePoint Foundation Search to configure it. Enter the following values:
   1. Service account: DOMAIN\SP10_Search
   2. Content access account: DOMAIN\SP10_Crawl
   3. Search database: SP10Admin1
   4. Database name: WSS_Search (remove any server name or GUID)
   5. Leave Windows Authentication selected. Leave Failover blank. Leave Hourly selected.
   6. Press OK
3. Allow the server to process those settings. The services list will return.
4. Press Start next to SharePoint Foundation Search. The settings screen will reappear, just press Start at the bottom of the screen (your settings seem to be gone but they are not, they're saved. Make no changes.)

Join Servers to Farm

The next step is to join the servers to the farm. Perform the following action on each SharePoint Server in the farm:

1. Log on to the server using the SP10_Setup account and run the SharePoint 2010 Products Configuration Wizard.
2. On the wizard, click Next on the introduction screen and accept the warning about services being stopped.
3. Select Connect to an existing server farm, and type in SP10Admin1 for the database; Press Retrieve database names. This will verify SQL Aliases are working properly. SharePoint_Config should be selected. Press Next.
4. On Specify Farm Security Settings, enter the Passphrase: Sh@r3F@rm. Click Next.
5. Review the summary and click Next. The wizard will go through 9-10 steps and join the server to the farm.
6. Once finished, click finish. The Central Administration Web Site will open in the browser and ask you to login. Press Cancel and close the browser.
7. Repeat the steps above for all other SharePoint Servers in the Farm.

Install Updates

• http://support.microsoft.com/default.aspx/kb/968930

Additional Configuration

Enable Developer Dashboard

Do this on any SharePoint server to enable the Developer Dashboard on the farm

stsadm -o setproperty -pn developer-dashboard -pv OnDemand

or

$dash = [Microsoft.SharePoint.Administration.SPWebService]::ContentService.DeveloperDashboardSettings; 
$dash.DisplayLevel = 'OnDemand'; 
$dash.TraceEnabled = $true; 
$dash.Update()

PowerShell scripts to do this can be downloaded from Todd Klindts Blog