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.
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
Accepted answer
-
Bhargava-MSFT 29,266 Reputation points Microsoft Employee
2023-04-10T21:59:55.27+00:00