Fixing « The Distributor has not been installed correctly » Error with AWS


The Problem

To migrate a SQL Server database to AWS or to implement a data migration/transfer strategy to AWS, a common tool we use is the Data Migration Service (DMS). This is a native AWS tool and supports many different database technologies, including Microsoft SQL Server. However, when connecting to SQL Server, one of the common errors raised is « The Distributor has not been installed correctly ».

This problem is raised not only with DMS, but also with other tools such as Qlik. The text below shows detailed errors raised in two different scenarios.

=================================================================================

Stream component ‘XXXXXXXX’ terminated Cannot initialize