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

Use Windows 2008 R2 so we can install SharePoint 2010 Foundation
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 video of the installation

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

Install MS SQL 2012 with Reporting Service for SharePoint add-in

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)

Installation Type Role and Feature widows Server 2012

Server Roles Application Server Windows Server 2012

Web Server Role- Role Services Health and Diagnostics

Web Server Role- Role Services Application Development

Add Roles and Features Wizard Application Development

Add Roles and Features Wizards ISAPI Extensions

Web Server Role- Role Services ASP.NET 3.5

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

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)

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

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

Change app pool to .NET Framework version 2.0

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

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

Start SharePoint CA

Set Application Pool Default to v 2.0 instead of v 4.0

Configure SharePoint 2010

Configure SharePoint Center Administration Web Application set port number

Completing the SharePoint Products Configuration Wizard

SharePoint Product Configuration Wizard Configuration Successful

provision the installation and configuration, just open CA

8 thoughts on “Install SharePoint 2010 with MS SQL Server 2012 on Windows Server 2012”

Thank you! This is really good info!
zee

Excelent!

where Specify database access acount I dont understand what username and what password I must write in

Mohamed Radwan | October 11, 2012 at 4:21 am

When you install the SQL, review the image or the screen of “Database Engine Configuration” you will see add the current user button, you should click on this button to add the account that you are using in this moment and this account what you will use.

In my case it was mradwan and my account password, and you can see in the image that it added.

You can also see the video for better understanding.

Reply

Thanks very much, this was a big help. I Thought that SharePoint 2010 is not supported on Windws Server 2012, or this what I found on microsoft site.

http://support.microsoft.com/kb/2724471

After reading this can you please explain what does the above link means for us as a sharepoint pro? [I don't want to purchase a licence of Win Server 2012, knowing that it is not supported]

If you please does the Standard Edition from (SQL 2012 and Windows server 2012) is enouph for implementing Sharepoint 2010 Enterprise Features?

Thank you Mohamed for your kind support, waiting your response.

Hello Osama, I am glad it helps

For the not supported link, there are more than reason for that,start from that the supported here meaning that you can’t without workaround, they didn’t have a clear path and so on….

Yes the standard edition will be enough as I know, but if you want to make sure you have to ask Microsoft, you can use the following forum

http://social.msdn.microsoft.com/Forums/en-US/sharepointgeneralprevious/threads

Thanks