SQL Server 2016 : Dropping Database Master Key used for encryption
Nimish Rao
![Nimish Rao]()
Nimish Rao
Data, Analytics and AI || Driving Business outcomes with Data, Analytics and AI
Have you ever had a problem dropping the database master key? I was at a client and I wanted to drop the master key. But i was getting an error which read : "Cannot drop key because CREDENTIALS my-DB-Scoped-Cred.databases.windows.net is encrypted by it". I tried a few things but what eventually worked for me was this command :
DROP DATABASE SCOPED CREDENTIAL [my-DB-Scoped-Cred.databases.windows.net]
GO
DROP DATABASE SCOPED CREDENTIAL [my-DB2-Scoped-Cred.databases.windows.net]
GO
DROP MASTER KEY
There is not a lot of documentation online on SQL Server 2016, I thought this might help someone out there.
What has been your experience of working with SQL Server 2016? Let me know in comments.
IT Systems Engineer at INIT Innovations in Transportation, Inc.
3 年Thanks for the tip. This worked in our case.
Data, Analytics and AI || Driving Business outcomes with Data, Analytics and AI
8 年and then try dropping the master key again
Data, Analytics and AI || Driving Business outcomes with Data, Analytics and AI
8 年hey mate run end conversation "give dialogue guid here"
SQL Server Database Administrator | High Availability & Disaster Recovery Specialist | Performance Tuning & Data Security Expert
8 年Can you help me with this error? Msg 15580, Level 16, State 3, Line 1 Cannot drop master key because dialog 'EED15E37-5AC9-4850-A0D3-00000005A121' is encrypted by it.