Install SharePoint 2010 with MS SQL Server 2012 on Windows Server 2012

Install SharePoint 2010 with MS SQL Server 2012 on Windows Server 2012

When I start my journey of install Team Foundation Server 2012 (TFS) on Windows Server 2012 with MS SQL 2012, I knew that we can't install SharePoint Foundation 2010 on Windows Server 2012, this by design and sure the Team Foundation Server (TFS) standard configuration will not be able to do that :-(

And if we want to install SharePoint Server 2010 with Team Foundation Server (TFS) 2012 we have 2 options

  1. Use Windows 2008 R2 so we can install SharePoint 2010 Foundation
  2. Use SharePoint Server 2010  so we can be able to install it on Windows Server 2012

So I try to install SharePoint prerequisites but it fails and give me the following error

There was an error during installation.

The tool was unable to install Application Server Role. Web Server (IIS) Role. configuration error, installation skipped

This happen for many reason, for example most of the prerequeist not supported for Windows Server 2012 because some of them become part of the Windows Server 2012 and some of them become par of the MS SQL 2012 as we will see later in this post.
So I try to install SharePoint and skip the prerequiest  and I found the following errors

This product requires the windows identity foundation
This product requires Microsoft Sync Framework Runtime v1.0(x64)
This product requires Microsoft SQL Server 2008 Native Client. Install SQL Server 2008 Native Client and re-run setup.
Windows Features or Role Service required by this product are not enabled. For a complete list, refer to the link below.
This product requires Microsoft Filter pack 2.0
This product requires internet information services (IIS) 7.0 or higher, with ASP >NET v2.0 set to 'Allow' in the list of IIS Web Server Extensions.
This product requires the IIS 6 Management Compatibility component to install
This product requires Microsoft Chart Controls for Microsoft .NET Framework 3.5 to be installed.

For more info about MS SQL Server 2012

For more info about Windows Server 2012

So Windows Identity Foundation become a Windows Server 2012 Role, so we just enable this Role on Windows 2012 Server

Also the Reporting Service SharePoint add-in become a component in MS SQL Server 2012

Note: Only SharePoint 2010 SP1 supported for MS SQL Server 2012 and even if the installation success without SP1 the configuration will fail.

So the steps to install SharePoint 2010 Server on Windows Server 2012 with MS SQL Server 2012 will be as the following

  • Install MS SQL 2012 with SharePoint add-in
  • Configure some Windows 2012 Roles and Features manually
  • Return specific Environment.Exit code
  • Run SharePoint 2010 prerequiest  and install them from SharePoint 2010 Server SP1 (Only SharePoint 2010 SP1 support MS SQL Server2012)
  • Install SharePoint 2010 Server SP1
  • Set the default app pool to v 2.0 instead of 4.0 because this what SharePoint 2010 needs
  • Configure SharePoint 2010
  • provision the installation and configuration
Note: you may want to setup SharePoint 2010 with SQL Server 2012 on Windows Server 2008 R2, it's OK, you can follow the same steps.

Here is the step-by-step video



If you prefer to follow steps with screen shots, review the following steps
























  • Configure some Windows 2012 Roles and Features manually
We will choose 2 Roles and 1 feature and for each Role we will choose it's features and so the feature, we will choose it's components
  • Web IIS (Role)
  • Application Server (Role)
  • Windows Identity Foundation 3.5 (Feature)

Add Roles and Features Windows 2012



Installation Type Role and Feature widows Server 2012



Server Selection Windows Server 2012



Server Roles Windows Server 2012






Server Roles Application Server Windows Server 2012



Feature Windows Identify Foundation 3.5



Web Server Role- Role Services Health and Diagnostics



Web Server Role- Role Services Security



Web Server Role- Role Services Application Development



Add Roles and Features Wizard Application Development



Add Roles and Features Wizard ASP



Add Roles and Features Wizards ISAPI Extensions



Web Server Role- Role Services ASP.NET 3.5



Add Roles and Features- ISAPI Filters






Web Server Role- Role Services Management Console



Add Roles and Features -II6 WMI Compatibility



Web Server Role- Role Service Scripting Tools



Application Server-Role Services Distributed Transactions



Add Roles and Features ASP.NET 4.5



Application Server-Role Services TCP Activation



Application Server-Role Services Windows Process Activation


Install Windows Server 2012 Roles and Features



  • Return specific Environment.Exit code
We will just give installation what it need, it just check for exist code 1003 so we will give this to SharePoint installation app, this was provided by Steve, well done Steve, its really helpful, so we will download the exe or just compile the source and put it in System32 Folder





  • Run SharePoint 2010 prerequiest  and install them from SharePoint 2010 Server SP1 (Only SharePoint 2010 SP1 support MS SQL Server2012)

Install SharePoint 2010 Prerequisites



Microsoft SharePoint 2010 Product Preparation Tool



Configure Application Server Role - Web Server (IIS) Role



SharePoint 2010 Product Preparation Tool Installation Complete






  • Install SharePoint 2010 Server SP1


Install SharePoint 2010 SP1




SharePoint 2010 Accept the terms



Install SharePoint Complete Server Farm







  • Set the default app pool to v 2.0 instead of 4.0 because this what SharePoint 2010 needs

Open the default app pool



Change app pool to .NET Framework version 2.0




If we didn't set this the configuration will fail as the following

SharePoint Products Configuration Wizard Configuration Failed


If this happen we will need to the change the app pool for crated pools related to SharePoint, after SharePoint configuration failed

Change the Application Pool Runtime



Change the Application Pool Runtime


Start SharePoint CA

Set Application Pool Default to v 2.0 instead of v 4.0






  • Configure SharePoint 2010


Create New Server Farm



Create a new Server Farm



Specify Configuration Database settings



Configure SharePoint Center Administration Web Application set port number



Completing the SharePoint Products Configuration Wizard



Configure SharePoint Products



SharePoint Product Configuration Wizard Configuration Successful

  • provision the installation and configuration, just open CA

Open SharePoint Center Administration

Leave a Comment
  • Please add 7 and 7 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
  • M.Radwan edited Revision 2. Comment: Add video

Page 1 of 1 (1 items)