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