Skip to content
The Bits That Byte
  • About
February 16, 2018 / Sitecore

Sitecore 9 Update 1 SIF Prerequisites for a Scaled Environment

If you are following the Sitecore 9 Update 1 Installation Guide, you may note that the prerequisites for SIF can lead to failures with SQL Communication if you are installing a scaled Sitecore environment (ex. SQL is installed on one server, while your Sitecore roles are installed on separate servers).

You may not experience issues if you are installing Sitecore via SIF on the same servers as SQL or have SSMS installed on your Sitecore servers. This is because SQL and SSMS contain .dlls and files for SQL communication that a server without these components will lack.

For those deploying Production environments that are scaled with SQL separate of the Sitecore roles, it is imperative to ensure that you have the full prerequisites for a scaled environment, as it is atypical to install SSMS on scaled/production boxes. The following “SIF Prerequisites for a Scaled Environment” meet these requirements and are not currently in the Sitecore documentation as of the writing of this post. Please review the Sitecore documentation on a regular cadence for any changes that could affect the required prerequisites, including application improvements.

The “SIF Prerequisites for a Scaled Environment” are intended to be installed in order, with notes on sub prereqs such as SQLSysCLRTypes being a sub prereq for DacFx. IMPORTANT: This assumes you are installing Sitecore on Windows 2016 (Highly recommended as it contains IIS 10.0 and .NET 4.6):

SIF Prerequisites for a Scaled Environment

Prerequisite Name Download Location and/or Installation Instructions
WebAdministration module (IIS) Server Manager > Add Roles and Features or “Install-WindowsFeature -name Web-Server -IncludeManagementTools” PowerShell Command
ASP.NET 4.6 (4.6.2) Server Manager > Add Roles and Features or “Install-WindowsFeature -name Web-Asp-Net45” PowerShell Command
Microsoft Visual C++ 2015 Redistributable Update 3 https://www.microsoft.com/en-us/download/details.aspx?id=53587
Web Platform Installer https://www.microsoft.com/web/downloads/platform.aspx
Web Deploy 3.6 for Hosting Server Install via the Web Platform Installer
URL Rewrite 2.1 Install via the Web Platform Installer
Microsoft SQL Server TransactSQLScriptDom (2016 x64 and x86) https://www.microsoft.com/en-us/download/details.aspx?id=52676 Install both x64 and x86 versions, installing x86 version first
SQLSysCLRTypes (2016 x64 and x86) https://www.microsoft.com/en-us/download/details.aspx?id=52676 Install both x64 and x86 versions, installing x86 version first. Sub Prereq for DacFx
Microsoft SQL Server Data-Tier Application Framework (DacFx) version 2016 (2016 x64 and x86) https://www.microsoft.com/en-us/download/details.aspx?id=52676 Install both x64 and x86 versions, installing x86 version first
Microsoft Shared Management Objects for SQL Server 2016 (2016 x64 and x86) https://www.microsoft.com/en-us/download/details.aspx?id=52676 Install both x64 and x86 versions, installing x86 version first
Microsoft ODBC Drivers for Microsoft SQL Server (Version 13.1 x64) https://www.microsoft.com/en-us/download/details.aspx?id=53339 Install only the x64 version. Sub Prereq for Microsoft Command Line Utilities 13.1 for SQL Server
Microsoft Command Line Utilities 13.1 or Greater for SQL Server (Version 13.1 x64) https://www.microsoft.com/en-us/download/details.aspx?id=53591 Microsoft updated the 13.1 Utility page to Version 14.0, but it still requires the 13.1 ODBC Drivers
SQL Server PowerShell Module Add “Install-Module -Name SqlServer -AllowClobber” and “Import-Module -Name SqlServer -Force” to the top of your SIF Installation Script to download and import the SQL Server PowerShell Module

Post navigation

Previous Post:

Preparing for an AngularJS AdSense and SEO Friendly Site

Next Post:

Sitecore 9 SIF Version 1.2.0 Released

One comment

  1. Pingback: you-must-have-a-user-with-the-same-password-in-master-or-target-server error while installing Sitecore 9.0.2 in SQL 2017-fixed – Ankit Joshi's Sitecore Blog

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Sitecore Technology MVP

Categories

  • AngularJS
  • Azure
  • CSS3
  • HTML5
  • Hyper-V
  • JavaScript
  • jQuery
  • OneDrive
  • PowerShell
  • Responsive Web Design
  • Search
  • SEO
  • SharePoint
  • Sitecore
  • SQL 2008 R2
  • SQL 2012
  • Tech Review
  • Tech Toy
  • Technical Resources
  • Uncategorized
  • Visual Studio
  • Web Content Management
  • Windows 8
  • Windows 8 App
  • Windows App
  • Windows Server 2008 R2
  • Workflow

Sponsored Links

Recent Posts

  • Autofail: A Big Azure Autoscale Limitation and What To Do
  • Got Fixes? A Sitecore Troubleshooters Guide to Sitecore Hotfixes
  • Sitecore 10 Application Roles, Storage Roles, and Indexes
  • Don’t Copy Sitecore Databases Across Environments, Sync Instead
  • Hey Sitecore PaaS! Where are My Modules?

Blogroll

  • Colins Sitecore Tech Blog
  • Sitecore Architecture – Grant's Sitecore Rants
January 2021
M T W T F S S
 123
45678910
11121314151617
18192021222324
25262728293031
« Dec    
© 2021 thebitsthatbyte.com - Powered by SimplyNews