This is Part 3 of a multi-part series on how to deploy a complete end-to-end Federated Web SSO solution using Windows Server 2012 R2's AD FS role and the Web Application Proxy. In this part I will deploy CONTOSO's and FABRIKAM's SQL 2014 Standard servers. In case you missed it:
Here is Part 1 - Overview
Here is Part 2 - Installing AD DS, AD CS, and DNS Records
The following topology highlights in yellow the two servers that will be built for this part and where they fit into the overall topology. If you wish to see the full topology click here.
SharePoint 2013 needs a SQL database to store its information as does Windows Server 2012 R2's AD FS Federation Service if the AD FS role will be deployed in a highly available configuration. You can read more about how each service uses databases via the following links:
SharePoint 2013: Hardware and Software Requirements for SharePoint 2013
Windows Server 2012 R2 AD FS: The Role of the AD FS Configuration Database
Deploy CONTOSO's SQL 2014 Server
Deploy FABRIKAM's SQL 2014 Server
You now have two forests one named contoso.com and one named fabrikam.com along with the DNS records and certificate services needed to support SharePoint 2013 and AD FS, and SQL 2014 installed in both forests to support each environment's database requirements. In the upcoming posts additional services will be deployed including SharePoint 2013, AD FS, the Web Application Proxy, and external DNS.