Azure synapse analytics synapse link error

Pavankumar-3526 306 Reputation points

When creating an azure synapse Link connection, getting the below error. Failed to enable Synapse Link on the source due to 'The database master key is missing.'. the linked server connection is successful Please note, the master key is already created. create master key encryption by password = 'xxx' I tried again but no luck

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,485 questions
0 comments No comments
{count} votes

Accepted answer
  1. BhargavaGunnam-MSFT 27,661 Reputation points Microsoft Employee

    Hello pavankumar-3516, Please correct me if my understanding is wrong. You are trying to create an Azure synapse for SQL and getting the error. The error message indicates that the database master key is missing on the source SQL server. The Synapse Link service requires access to these keys to establishing a secure connection to the source SQL server. Please verify that the database master key was created successfully by running the following command. SELECT * FROM sys.symmetric_keys WHERE name LIKE '%DatabaseMasterKey%'; if the database is encrypted using TDE, you may need to enable Synapse Link on the source SQL server with the TDE option. ALTER DATABASE <database_name> SET ENCRYPTION ON; Then please try enabling Synapse Link again. I hope this helps. Please let me know if you have any further questions.

0 additional answers

Sort by: Most helpful