Sitecore 9 update 1 installation with SQL Server on a different server

Sitecore 9 update 1 was just released. So it’s quite fresh from the oven.

I’ve just tried the installation on a web machine that uses SQL Server installed on a different server and made some discoveries related with prerequisites  needed for the installation.

So beside the standard prerequisites mentioned in the installation documentation (must log into before downloading) there are couple requirements that have to be installed on your webserver:

    1. Microsoft SQL Server TransactSQLScriptDom – install both SqlDom.msi for x64 and x86 – install this before DacFx
    2. Microsoft Shared Management Objects for SQL Server 2016  – install both SharedManagementObjects.msi for x64 and x86
    3. Microsoft® SQL Server® 2016 Feature Pack
      1. Microsoft ODBC Drivers for Microsoft SQL Server – install both msodbcsql.msi for x64 and x86
      2. Microsoft Command Line Utilities 13 for SQL Server – install both MsSqlCmdLnUtils.msi for x64 and x86
    4. SQL Server PowerShell Module – by opening PowerShell as administrator and  run this command:
      Install-Module -Name SqlServer -AllowClobber
    5. Extra (so I find it later, even that is in the official documentation): Microsoft Visual C++ 2015 Redistributable – was introduced in this Sitecore 9 update 1 as its needed by ChilkatDotNet46.dll. Download from here.

I guess that’s all.

Happy installing and let me know if you need any assistance.


By Sebastian Tecsi

Sitecore MVP 2018-2021
Sitecore Architect

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

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