{"id":8205,"date":"2019-01-19T09:49:26","date_gmt":"2019-01-19T09:49:26","guid":{"rendered":"https:\/\/dbtut.com\/?p=8205"},"modified":"2019-01-19T09:49:26","modified_gmt":"2019-01-19T09:49:26","slug":"the-certificate-xxx-cannot-be-dropped-because-it-is-bound-to-one-or-more-database-encryption-keydeleting-a-certificate","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/01\/19\/the-certificate-xxx-cannot-be-dropped-because-it-is-bound-to-one-or-more-database-encryption-keydeleting-a-certificate\/","title":{"rendered":"The certificate &#8216;xxx&#8217; cannot be dropped because it is bound to one or more database encryption key(Deleting a Certificate)"},"content":{"rendered":"<p>&nbsp;<\/p>\n<p>You may need to delete the certificate that you created with TDE(Transparent Data Encryption) during the database encryption process. And during this deletion process, you may encounter an error as follows.<\/p>\n<p><em>The certificate &#8221; cannot be dropped because it is bound to one or more database encryption key. (Microsoft SQL Server, Error: 3716)<\/em><\/p>\n<p id=\"ZXqSPUk\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-8208  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c42f192d660f.png\" alt=\"\" width=\"591\" height=\"202\" \/><\/p>\n<p>In order to delete the certificate without taking this error, you must first find and delete database encryption keys associated with this certificate on the instance. You can reach this list with the help of the following query.<\/p>\n<pre class=\"lang:default decode:true\">select database_name = db.name,dek.encryptor_type, cert_name = mycert.name\r\nfrom sys.dm_database_encryption_keys dek\r\nleft join sys.certificates mycert on dek.encryptor_thumbprint = mycert.thumbprint\r\ninner join sys.databases db on dek.database_id = db.database_id\r\nwhere mycert.name is not null<\/pre>\n<p>The result of this query will be similar to the following screen output.<\/p>\n<p id=\"OgdjPgs\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-8210  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c42f1ceb983a.png\" alt=\"\" width=\"598\" height=\"241\" \/><\/p>\n<p>The certificate we are trying to delete is called &#8220;Sertifikam&#8221; The database name associated with this certificate is called &#8220;denemeveri&#8221;. In order to delete our certificate, we have to delete the database encryption key in the database &#8220;denemeveri&#8221;. We can do this as follows.<\/p>\n<p>First, we are turning off the encryption on the database.<\/p>\n<pre class=\"lang:default decode:true\">ALTER DATABASE denemeveri\u00a0\r\nSET ENCRYPTION OFF;\u00a0\r\nGO<\/pre>\n<p>Then wait until the result of the following query arrives 1.<\/p>\n<pre class=\"lang:default decode:true\">SELECT encryption_state\u00a0\r\nFROM sys.dm_database_encryption_keys;\u00a0\r\nGO<\/pre>\n<p>Then we delete the dek(database encryption key) in the following way.<\/p>\n<pre class=\"lang:default decode:true\">USE denemeveri;\u00a0\r\nGO\u00a0\r\nDROP DATABASE ENCRYPTION KEY;\u00a0\r\nGO<\/pre>\n<p>After deleting dek, you can delete your certificate without error.<\/p>\n<p id=\"hJRnOfA\"><img loading=\"lazy\" decoding=\"async\" width=\"491\" height=\"635\" class=\"size-full wp-image-8212  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c42f225c7db7.png\" alt=\"\" \/><\/p>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_8205\" class=\"pvc_stats all  \" data-element-id=\"8205\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; You may need to delete the certificate that you created with TDE(Transparent Data Encryption) during the database encryption process. And during this deletion process, you may encounter an error as follows. The certificate &#8221; cannot be dropped because it is bound to one or more database encryption key. (Microsoft SQL Server, Error: 3716) In &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_8205\" class=\"pvc_stats all  \" data-element-id=\"8205\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[3],"tags":[],"class_list":["post-8205","post","type-post","status-publish","format-standard","","category-mssql"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>The certificate &#039;xxx&#039; cannot be dropped because it is bound to one or more database encryption key(Deleting a Certificate) - Database Tutorials<\/title>\n<meta name=\"description\" content=\"The certificate &#039;xxx&#039; cannot be dropped because it is bound to one or more database encryption key(Deleting a Certificate)\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2019\/01\/19\/the-certificate-xxx-cannot-be-dropped-because-it-is-bound-to-one-or-more-database-encryption-keydeleting-a-certificate\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"The certificate &#039;xxx&#039; cannot be dropped because it is bound to one or more database encryption key(Deleting a Certificate) - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"The certificate &#039;xxx&#039; cannot be dropped because it is bound to one or more database encryption key(Deleting a Certificate)\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/01\/19\/the-certificate-xxx-cannot-be-dropped-because-it-is-bound-to-one-or-more-database-encryption-keydeleting-a-certificate\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-01-19T09:49:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c42f192d660f.png\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/19\/the-certificate-xxx-cannot-be-dropped-because-it-is-bound-to-one-or-more-database-encryption-keydeleting-a-certificate\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/19\/the-certificate-xxx-cannot-be-dropped-because-it-is-bound-to-one-or-more-database-encryption-keydeleting-a-certificate\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"The certificate &#8216;xxx&#8217; cannot be dropped because it is bound to one or more database encryption key(Deleting a Certificate)\",\"datePublished\":\"2019-01-19T09:49:26+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/19\/the-certificate-xxx-cannot-be-dropped-because-it-is-bound-to-one-or-more-database-encryption-keydeleting-a-certificate\/\"},\"wordCount\":214,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/19\/the-certificate-xxx-cannot-be-dropped-because-it-is-bound-to-one-or-more-database-encryption-keydeleting-a-certificate\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c42f192d660f.png\",\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/01\/19\/the-certificate-xxx-cannot-be-dropped-because-it-is-bound-to-one-or-more-database-encryption-keydeleting-a-certificate\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/19\/the-certificate-xxx-cannot-be-dropped-because-it-is-bound-to-one-or-more-database-encryption-keydeleting-a-certificate\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/19\/the-certificate-xxx-cannot-be-dropped-because-it-is-bound-to-one-or-more-database-encryption-keydeleting-a-certificate\/\",\"name\":\"The certificate 'xxx' cannot be dropped because it is bound to one or more database encryption key(Deleting a Certificate) - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/19\/the-certificate-xxx-cannot-be-dropped-because-it-is-bound-to-one-or-more-database-encryption-keydeleting-a-certificate\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/19\/the-certificate-xxx-cannot-be-dropped-because-it-is-bound-to-one-or-more-database-encryption-keydeleting-a-certificate\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c42f192d660f.png\",\"datePublished\":\"2019-01-19T09:49:26+00:00\",\"description\":\"The certificate 'xxx' cannot be dropped because it is bound to one or more database encryption key(Deleting a Certificate)\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/19\/the-certificate-xxx-cannot-be-dropped-because-it-is-bound-to-one-or-more-database-encryption-keydeleting-a-certificate\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/01\/19\/the-certificate-xxx-cannot-be-dropped-because-it-is-bound-to-one-or-more-database-encryption-keydeleting-a-certificate\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/19\/the-certificate-xxx-cannot-be-dropped-because-it-is-bound-to-one-or-more-database-encryption-keydeleting-a-certificate\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c42f192d660f.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c42f192d660f.png\",\"width\":720,\"height\":246},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/19\/the-certificate-xxx-cannot-be-dropped-because-it-is-bound-to-one-or-more-database-encryption-keydeleting-a-certificate\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"The certificate &#8216;xxx&#8217; cannot be dropped because it is bound to one or more database encryption key(Deleting a Certificate)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"The certificate 'xxx' cannot be dropped because it is bound to one or more database encryption key(Deleting a Certificate) - Database Tutorials","description":"The certificate 'xxx' cannot be dropped because it is bound to one or more database encryption key(Deleting a Certificate)","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbtut.com\/index.php\/2019\/01\/19\/the-certificate-xxx-cannot-be-dropped-because-it-is-bound-to-one-or-more-database-encryption-keydeleting-a-certificate\/","og_locale":"en_US","og_type":"article","og_title":"The certificate 'xxx' cannot be dropped because it is bound to one or more database encryption key(Deleting a Certificate) - Database Tutorials","og_description":"The certificate 'xxx' cannot be dropped because it is bound to one or more database encryption key(Deleting a Certificate)","og_url":"https:\/\/dbtut.com\/index.php\/2019\/01\/19\/the-certificate-xxx-cannot-be-dropped-because-it-is-bound-to-one-or-more-database-encryption-keydeleting-a-certificate\/","og_site_name":"Database Tutorials","article_published_time":"2019-01-19T09:49:26+00:00","og_image":[{"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c42f192d660f.png","type":"","width":"","height":""}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/19\/the-certificate-xxx-cannot-be-dropped-because-it-is-bound-to-one-or-more-database-encryption-keydeleting-a-certificate\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/19\/the-certificate-xxx-cannot-be-dropped-because-it-is-bound-to-one-or-more-database-encryption-keydeleting-a-certificate\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"The certificate &#8216;xxx&#8217; cannot be dropped because it is bound to one or more database encryption key(Deleting a Certificate)","datePublished":"2019-01-19T09:49:26+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/19\/the-certificate-xxx-cannot-be-dropped-because-it-is-bound-to-one-or-more-database-encryption-keydeleting-a-certificate\/"},"wordCount":214,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/19\/the-certificate-xxx-cannot-be-dropped-because-it-is-bound-to-one-or-more-database-encryption-keydeleting-a-certificate\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c42f192d660f.png","articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/01\/19\/the-certificate-xxx-cannot-be-dropped-because-it-is-bound-to-one-or-more-database-encryption-keydeleting-a-certificate\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/19\/the-certificate-xxx-cannot-be-dropped-because-it-is-bound-to-one-or-more-database-encryption-keydeleting-a-certificate\/","url":"https:\/\/dbtut.com\/index.php\/2019\/01\/19\/the-certificate-xxx-cannot-be-dropped-because-it-is-bound-to-one-or-more-database-encryption-keydeleting-a-certificate\/","name":"The certificate 'xxx' cannot be dropped because it is bound to one or more database encryption key(Deleting a Certificate) - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/19\/the-certificate-xxx-cannot-be-dropped-because-it-is-bound-to-one-or-more-database-encryption-keydeleting-a-certificate\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/19\/the-certificate-xxx-cannot-be-dropped-because-it-is-bound-to-one-or-more-database-encryption-keydeleting-a-certificate\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c42f192d660f.png","datePublished":"2019-01-19T09:49:26+00:00","description":"The certificate 'xxx' cannot be dropped because it is bound to one or more database encryption key(Deleting a Certificate)","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/19\/the-certificate-xxx-cannot-be-dropped-because-it-is-bound-to-one-or-more-database-encryption-keydeleting-a-certificate\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/01\/19\/the-certificate-xxx-cannot-be-dropped-because-it-is-bound-to-one-or-more-database-encryption-keydeleting-a-certificate\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/19\/the-certificate-xxx-cannot-be-dropped-because-it-is-bound-to-one-or-more-database-encryption-keydeleting-a-certificate\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c42f192d660f.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c42f192d660f.png","width":720,"height":246},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/19\/the-certificate-xxx-cannot-be-dropped-because-it-is-bound-to-one-or-more-database-encryption-keydeleting-a-certificate\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"The certificate &#8216;xxx&#8217; cannot be dropped because it is bound to one or more database encryption key(Deleting a Certificate)"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/8205","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=8205"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/8205\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=8205"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=8205"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=8205"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}