{"id":2151,"date":"2020-01-23T14:17:33","date_gmt":"2020-01-23T19:17:33","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/jonathan\/?p=2151"},"modified":"2020-01-24T11:14:00","modified_gmt":"2020-01-24T16:14:00","slug":"keyset-does-not-exist-add-clusternode","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/keyset-does-not-exist-add-clusternode\/","title":{"rendered":"Keyset Does Not Exist &#8211; Add-ClusterNode"},"content":{"rendered":"<p>While working on a video recording for Paul this week I ran into an interesting problem with one of my Windows Server 2016 clusters. While attempting to add a new node to the cluster I ran into an exception calling Add-ClusterNode:<\/p>\n<p style=\"padding-left: 40px;\"><em>The server &#8216;SQL2K16-AG03.SQLskillsDemos.com&#8217; could not be added to the cluster.<\/em><br \/>\n<em>An error occurred while adding node &#8216;SQL2K16-AG03.SQLskillsDemos.com&#8217; to cluster &#8216;SQL2K16-WSFC&#8217;.<\/em><\/p>\n<p style=\"padding-left: 40px;\"><em>Keyset does not exist<\/em><\/p>\n<p>The windows account I was using was the domain administrator account and I had just recently made modifications that involved the certificate store on this specific VM, so I decided to take a backup of the VMDK and then revert to a snapshot to try again, and this time it worked.\u00a0 So needless to say I was intrigued as to what I could have done that would be causing this error to happen.\u00a0 It turns out that while installing a SSL certificate for SQL Server to use, I had negatively impacted the permissions for the C:\\ProgramData\\Microsoft\\Crypto\\RSA folder, and the keys that are protected inside of that folder, which happen to be the private keys for the certificates on the server.\u00a0 The normal permissions for this folder can be seen on the screenshot from the working node in the cluster.<\/p>\n<p><strong>UPDATE: 1\/24\/2020 &#8211; A reader provided a link from Microsoft Support for the default permissions as well (<a href=\"https:\/\/support.microsoft.com\/en-us\/help\/278381\/\">https:\/\/support.microsoft.com\/en-us\/help\/278381\/<\/a>)\u00a0<\/strong><\/p>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter size-full wp-image-2153\" src=\"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-content\/uploads\/2020\/01\/rsa-permissions-1.png\" alt=\"\" width=\"767\" height=\"520\" srcset=\"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-content\/uploads\/2020\/01\/rsa-permissions-1.png 767w, https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-content\/uploads\/2020\/01\/rsa-permissions-1-300x203.png 300w\" sizes=\"(max-width: 767px) 100vw, 767px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>On the broken copy of the VM, the Owner was not set, and none of the other permissions were even close to matching and inheritance had been propagated (oops!!!).\u00a0 The really crazy thing is, I don&#8217;t even know how exactly I caused this to happen at this point, but none of the keys were accessible to anything on that node. While I was able to go into the folder and manually set the Owner: and all the permissions on each of the Keys in the Machine folder to allow the node to be joined to the cluster, I ultimately went and evicted the node and rebuilt it instead of relying on manually applied permissions to make it work.\u00a0 \u00a0Here is why:<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-2154\" src=\"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-content\/uploads\/2020\/01\/machine-keys.png\" alt=\"\" width=\"767\" height=\"520\" srcset=\"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-content\/uploads\/2020\/01\/machine-keys.png 767w, https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-content\/uploads\/2020\/01\/machine-keys-300x203.png 300w\" sizes=\"(max-width: 767px) 100vw, 767px\" \/><\/p>\n<p>The owner of the folders is SYSTEM, which is easy to go back and set, but to set the permissions on the Keys inside the Machine Keys folder, you have to Take Ownership of the key:<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-2155\" src=\"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-content\/uploads\/2020\/01\/default-key-security.png\" alt=\"\" width=\"363\" height=\"509\" srcset=\"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-content\/uploads\/2020\/01\/default-key-security.png 363w, https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-content\/uploads\/2020\/01\/default-key-security-214x300.png 214w\" sizes=\"(max-width: 363px) 100vw, 363px\" \/><\/p>\n<p>Even as an Administrator, you don&#8217;t have Read access, so when you click the Advanced button, it can&#8217;t show any information and offers to try Administrative Permissions to do it, but again that fails when you click Continue to get the objects permissions you can only take ownership to view the properties, which then means you don&#8217;t know who the correct owner actually should have been.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2156\" src=\"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-content\/uploads\/2020\/01\/take-ownership.png\" alt=\"\" width=\"767\" height=\"520\" srcset=\"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-content\/uploads\/2020\/01\/take-ownership.png 767w, https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-content\/uploads\/2020\/01\/take-ownership-300x203.png 300w\" sizes=\"(max-width: 767px) 100vw, 767px\" \/><\/p>\n<p>However, in a real production down scenario where you made a mistake setting permissions and the cluster nodes can&#8217;t join into the cluster, start the cluster service correctly, or take ownership of the resources, manually taking ownership and setting permissions on the Keys as shown in this screenshot from another environment I intentionally destroyed the permissions on to try and complete this blog post, can get you out of a pinch.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2157\" src=\"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-content\/uploads\/2020\/01\/manually-set-permissions.png\" alt=\"\" width=\"767\" height=\"520\" srcset=\"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-content\/uploads\/2020\/01\/manually-set-permissions.png 767w, https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-content\/uploads\/2020\/01\/manually-set-permissions-300x203.png 300w\" sizes=\"(max-width: 767px) 100vw, 767px\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>While working on a video recording for Paul this week I ran into an interesting problem with one of my Windows Server 2016 clusters. While attempting to add a new node to the cluster I ran into an exception calling Add-ClusterNode: The server &#8216;SQL2K16-AG03.SQLskillsDemos.com&#8217; could not be added to the cluster. An error occurred while [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-2151","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Keyset Does Not Exist - Add-ClusterNode - Jonathan Kehayias<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.sqlskills.com\/blogs\/jonathan\/keyset-does-not-exist-add-clusternode\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Keyset Does Not Exist - Add-ClusterNode - Jonathan Kehayias\" \/>\n<meta property=\"og:description\" content=\"While working on a video recording for Paul this week I ran into an interesting problem with one of my Windows Server 2016 clusters. While attempting to add a new node to the cluster I ran into an exception calling Add-ClusterNode: The server &#8216;SQL2K16-AG03.SQLskillsDemos.com&#8217; could not be added to the cluster. An error occurred while [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/jonathan\/keyset-does-not-exist-add-clusternode\/\" \/>\n<meta property=\"og:site_name\" content=\"Jonathan Kehayias\" \/>\n<meta property=\"article:published_time\" content=\"2020-01-23T19:17:33+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-01-24T16:14:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-content\/uploads\/2020\/01\/rsa-permissions-1.png\" \/>\n<meta name=\"author\" content=\"Jonathan Kehayias\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jonathan Kehayias\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/keyset-does-not-exist-add-clusternode\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/keyset-does-not-exist-add-clusternode\\\/\"},\"author\":{\"name\":\"Jonathan Kehayias\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/#\\\/schema\\\/person\\\/01c10d94f3648654ef706d5e6305f69c\"},\"headline\":\"Keyset Does Not Exist &#8211; Add-ClusterNode\",\"datePublished\":\"2020-01-23T19:17:33+00:00\",\"dateModified\":\"2020-01-24T16:14:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/keyset-does-not-exist-add-clusternode\\\/\"},\"wordCount\":545,\"commentCount\":1,\"image\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/keyset-does-not-exist-add-clusternode\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/wp-content\\\/uploads\\\/2020\\\/01\\\/rsa-permissions-1.png\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/keyset-does-not-exist-add-clusternode\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/keyset-does-not-exist-add-clusternode\\\/\",\"url\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/keyset-does-not-exist-add-clusternode\\\/\",\"name\":\"Keyset Does Not Exist - Add-ClusterNode - Jonathan Kehayias\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/keyset-does-not-exist-add-clusternode\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/keyset-does-not-exist-add-clusternode\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/wp-content\\\/uploads\\\/2020\\\/01\\\/rsa-permissions-1.png\",\"datePublished\":\"2020-01-23T19:17:33+00:00\",\"dateModified\":\"2020-01-24T16:14:00+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/#\\\/schema\\\/person\\\/01c10d94f3648654ef706d5e6305f69c\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/keyset-does-not-exist-add-clusternode\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/keyset-does-not-exist-add-clusternode\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/keyset-does-not-exist-add-clusternode\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/wp-content\\\/uploads\\\/2020\\\/01\\\/rsa-permissions-1.png\",\"contentUrl\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/wp-content\\\/uploads\\\/2020\\\/01\\\/rsa-permissions-1.png\",\"width\":767,\"height\":520},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/keyset-does-not-exist-add-clusternode\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Uncategorized\",\"item\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/category\\\/uncategorized\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Keyset Does Not Exist &#8211; Add-ClusterNode\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/#website\",\"url\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/\",\"name\":\"Jonathan Kehayias - The Rambling DBA\",\"description\":\"The Rambling DBA\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/#\\\/schema\\\/person\\\/01c10d94f3648654ef706d5e6305f69c\",\"name\":\"Jonathan Kehayias\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/86630e27f5deecc5c393ea57fc7c3b6a068949f4fd6b5309f81de5a276f12855?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/86630e27f5deecc5c393ea57fc7c3b6a068949f4fd6b5309f81de5a276f12855?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/86630e27f5deecc5c393ea57fc7c3b6a068949f4fd6b5309f81de5a276f12855?s=96&d=mm&r=g\",\"caption\":\"Jonathan Kehayias\"},\"sameAs\":[\"http:\\\/\\\/3.209.169.194\\\/blogs\\\/jonathan\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Keyset Does Not Exist - Add-ClusterNode - Jonathan Kehayias","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:\/\/www.sqlskills.com\/blogs\/jonathan\/keyset-does-not-exist-add-clusternode\/","og_locale":"en_US","og_type":"article","og_title":"Keyset Does Not Exist - Add-ClusterNode - Jonathan Kehayias","og_description":"While working on a video recording for Paul this week I ran into an interesting problem with one of my Windows Server 2016 clusters. While attempting to add a new node to the cluster I ran into an exception calling Add-ClusterNode: The server &#8216;SQL2K16-AG03.SQLskillsDemos.com&#8217; could not be added to the cluster. An error occurred while [&hellip;]","og_url":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/keyset-does-not-exist-add-clusternode\/","og_site_name":"Jonathan Kehayias","article_published_time":"2020-01-23T19:17:33+00:00","article_modified_time":"2020-01-24T16:14:00+00:00","og_image":[{"url":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-content\/uploads\/2020\/01\/rsa-permissions-1.png","type":"","width":"","height":""}],"author":"Jonathan Kehayias","twitter_misc":{"Written by":"Jonathan Kehayias","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/keyset-does-not-exist-add-clusternode\/#article","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/keyset-does-not-exist-add-clusternode\/"},"author":{"name":"Jonathan Kehayias","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/#\/schema\/person\/01c10d94f3648654ef706d5e6305f69c"},"headline":"Keyset Does Not Exist &#8211; Add-ClusterNode","datePublished":"2020-01-23T19:17:33+00:00","dateModified":"2020-01-24T16:14:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/keyset-does-not-exist-add-clusternode\/"},"wordCount":545,"commentCount":1,"image":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/keyset-does-not-exist-add-clusternode\/#primaryimage"},"thumbnailUrl":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-content\/uploads\/2020\/01\/rsa-permissions-1.png","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.sqlskills.com\/blogs\/jonathan\/keyset-does-not-exist-add-clusternode\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/keyset-does-not-exist-add-clusternode\/","url":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/keyset-does-not-exist-add-clusternode\/","name":"Keyset Does Not Exist - Add-ClusterNode - Jonathan Kehayias","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/keyset-does-not-exist-add-clusternode\/#primaryimage"},"image":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/keyset-does-not-exist-add-clusternode\/#primaryimage"},"thumbnailUrl":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-content\/uploads\/2020\/01\/rsa-permissions-1.png","datePublished":"2020-01-23T19:17:33+00:00","dateModified":"2020-01-24T16:14:00+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/#\/schema\/person\/01c10d94f3648654ef706d5e6305f69c"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/keyset-does-not-exist-add-clusternode\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/jonathan\/keyset-does-not-exist-add-clusternode\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/keyset-does-not-exist-add-clusternode\/#primaryimage","url":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-content\/uploads\/2020\/01\/rsa-permissions-1.png","contentUrl":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-content\/uploads\/2020\/01\/rsa-permissions-1.png","width":767,"height":520},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/keyset-does-not-exist-add-clusternode\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/"},{"@type":"ListItem","position":2,"name":"Uncategorized","item":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/category\/uncategorized\/"},{"@type":"ListItem","position":3,"name":"Keyset Does Not Exist &#8211; Add-ClusterNode"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/#website","url":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/","name":"Jonathan Kehayias - The Rambling DBA","description":"The Rambling DBA","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/#\/schema\/person\/01c10d94f3648654ef706d5e6305f69c","name":"Jonathan Kehayias","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/86630e27f5deecc5c393ea57fc7c3b6a068949f4fd6b5309f81de5a276f12855?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/86630e27f5deecc5c393ea57fc7c3b6a068949f4fd6b5309f81de5a276f12855?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/86630e27f5deecc5c393ea57fc7c3b6a068949f4fd6b5309f81de5a276f12855?s=96&d=mm&r=g","caption":"Jonathan Kehayias"},"sameAs":["http:\/\/3.209.169.194\/blogs\/jonathan"]}]}},"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/posts\/2151","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/comments?post=2151"}],"version-history":[{"count":1,"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/posts\/2151\/revisions"}],"predecessor-version":[{"id":2158,"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/posts\/2151\/revisions\/2158"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/media?parent=2151"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/categories?post=2151"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/tags?post=2151"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}