Knowledge

[OritA]

When performing a 'test connection' to Microsoft Azure Synapse Analytics target endpoint you may get the following error: 

SYS-E-HTTPFAIL, Master key was not found , please create master key

SYS,GENERAL_EXCEPTION,Master key was not found , please create master key

Cause 

Azure SQL DW requires to create a Master Key. The error above is displayed when master key is missing.

Resolution

Ask your DBA to create a master key using the following command:
CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'password';

Environment

• Replicate with  Microsoft Azure Synapse Analytics target