{"id":1084,"date":"2012-08-26T16:33:52","date_gmt":"2012-08-26T20:33:52","guid":{"rendered":"http:\/\/sqlity.net\/en\/?p=1084"},"modified":"2014-11-13T13:54:27","modified_gmt":"2014-11-13T18:54:27","slug":"renaming-a-windows-machine-hosting-sql-server","status":"publish","type":"post","link":"https:\/\/sqlity.net\/en\/1084\/renaming-a-windows-machine-hosting-sql-server\/","title":{"rendered":"Renaming a Windows Machine hosting SQL Server"},"content":{"rendered":"<div>\n<h3>Introduction<\/h3>\n<p>\nRenaming a Windows server hosting a SQL Server installation is fairly straight forward. Most of the changes necessary for SQL Server to continue to work happen automatically the next time SQL Server restarts. As a Windows rename requires a restart of the machine, SQL Server will restart at that time anyway.\n<\/p>\n<p>\nAfter SQL Server comes back up everything looks like the rename succeeded so the next step is often forgotten. However there are a few places were not executing this step is going to cause problems.\n<\/p>\n<h3>Replication<\/h3>\n<p>\nOne of these areas is configuring distribution when setting up replication. For the wizard to work properly it needs to know the actual server name. It gets that information from the <span class=\"tt\">@@SERVERNAME<\/span> variable. However this value does not automatically change when the underlying windows installation is renamed. The error you will get looks like this:\n<\/p>\n<p>\n<a href=\"http:\/\/sqlity.net\/wp-content\/uploads\/2012\/08\/SQL_Server_replication_requires_the_actual_server_name_to_make_a_connection_to_the_server.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/sqlity.net\/wp-content\/uploads\/2012\/08\/SQL_Server_replication_requires_the_actual_server_name_to_make_a_connection_to_the_server.jpg\" alt=\"SQL Server replication requires the actual server name to make a connection to the server\" title=\"SQL Server replication requires the actual server name to make a connection to the server\" width=\"611\" height=\"165\" class=\"aligncenter size-full wp-image-1086\" srcset=\"https:\/\/sqlity.net\/wp-content\/uploads\/2012\/08\/SQL_Server_replication_requires_the_actual_server_name_to_make_a_connection_to_the_server.jpg 611w, https:\/\/sqlity.net\/wp-content\/uploads\/2012\/08\/SQL_Server_replication_requires_the_actual_server_name_to_make_a_connection_to_the_server-300x81.jpg 300w\" sizes=\"auto, (max-width: 611px) 100vw, 611px\" \/><\/a>\n<\/p>\n<p>\nIt complains that you did not use the old name to connect to SQL Server.\n<\/p>\n<h3>The <span class=\"tt\">sys.servers<\/span> catalog view<\/h3>\n<p>The information that <span class=\"tt\">@@SERVERNAME<\/span> returns is also accessible using the <span class=\"tt\">sys.servers<\/span> catalog view:\n<\/p>\n<div>\n[sql]\nSELECT  server_id,name,is_linked<br \/>\nFROM    sys.servers;<br \/>\n[\/sql]\n<\/div>\n<p><style type=\"text\/css\">\ntable.tableizer-table {border: 1px solid #CCC; font-family: Arial, Helvetica, sans-serif; font-size: 12px;} .tableizer-table td {padding: 4px; margin: 3px; border: 1px solid #ccc;}\n.tableizer-table th {background-color: #104E8B; color: #FFF; font-weight: bold;}\n<\/style>\n<table class=\"tableizer-table\">\n<tr class=\"tableizer-firstrow\">\n<th>server_id<\/th>\n<th>name<\/th>\n<th>is_linked<\/th>\n<\/tr>\n<tr>\n<td>0<\/td>\n<td>OLDNAME\\S12A<\/td>\n<td>0<\/td>\n<\/tr>\n<tr>\n<td>1<\/td>\n<td>SQL0\\S12B<\/td>\n<td>1<\/td>\n<\/tr>\n<\/table>\n<p>\nThis query returns all linked servers. It also holds one entry for the local server.\n<\/p>\n<p>\nAll we need to do to get things back in order is to replace that first entry with the correct one. For that purpose SQL Server provides two procedures: <span class=\"tt\">sys.sp_dropserver<\/span> and <span class=\"tt\">sys.sp_addserver<\/span>. We can use them to just drop the old entry and add a new correct one as described here: : <a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/ms143799.aspx\">Rename a Computer that Hosts a Stand-Alone Instance of SQL Server<\/a>\n<\/p>\n<h3>The Script<\/h3>\n<p>\nI recently had to do this with a lot of servers. To reduce the manual work required I came up with a script to automate this step:\n<\/p>\n<div>\n[sql]\nDECLARE @OldServerName NVARCHAR(MAX), @NewServerName NVARCHAR(MAX);<br \/>\nSELECT @OldServerName = @@SERVERNAME, @NewServerName = CAST(SERVERPROPERTY('ServerName') AS NVARCHAR(MAX));<br \/>\nIF(@OldServerName &lt;&gt; @NewServerName)<br \/>\nBEGIN<br \/>\n  RAISERROR('Renaming server %s to %s...',0,1,@OldServerName,@NewServerName)WITH NOWAIT;<br \/>\n  EXEC sys.sp_dropserver @OldServerName;<br \/>\n  EXEC sys.sp_addserver @NewServerName, 'local';<br \/>\n  RAISERROR('Done.',0,1)WITH NOWAIT;<br \/>\nEND<br \/>\nELSE<br \/>\nBEGIN<br \/>\n  RAISERROR('Server %s does not need to be renamed...',0,1,@OldServerName)WITH NOWAIT;<br \/>\nEND;<br \/>\n[\/sql]\n<\/div>\n<p>\nThis script automatically figures out which server entry to drop and which to create, so you can run it against multiple servers without change.\n<\/p>\n<h3>Conclusion<\/h3>\n<p>\nThe above script provides an easy way to fix the situation where <span class=\"tt\">@@SERVERNAME<\/span> does not return the correct server name after the host machine was renamed.\n<\/p>\n<p>\nBefore you consider renaming a SQL Server hosting machine you should however read this BOL entry that list supported and unsupported cases: <a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/ms143799.aspx\">Rename a Computer that Hosts a Stand-Alone Instance of SQL Server<\/a>\n<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>\nRenaming a Windows server hosting a SQL Server installation is fairly straight forward. Most of the changes necessary for SQL Server to continue to work happen automatically the next time SQL Server restarts. However there is one notable exception\u2026\n<\/p>\n<p> <a href=\"https:\/\/sqlity.net\/en\/1084\/renaming-a-windows-machine-hosting-sql-server\/\">[more&#8230;]<\/a><\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[5],"tags":[],"class_list":["post-1084","post","type-post","status-publish","format-standard","hentry","category-general"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Renaming a Windows Machine hosting SQL Server - sqlity.net<\/title>\n<meta name=\"description\" content=\"Need to rename a computer hosting SQL Server? This post gives an automated solution for the changes required in every instance on the computer.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/sqlity.net\/en\/1084\/renaming-a-windows-machine-hosting-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Renaming a Windows Machine hosting SQL Server - sqlity.net\" \/>\n<meta property=\"og:description\" content=\"Need to rename a computer hosting SQL Server? This post gives an automated solution for the changes required in every instance on the computer.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sqlity.net\/en\/1084\/renaming-a-windows-machine-hosting-sql-server\/\" \/>\n<meta property=\"og:site_name\" content=\"sqlity.net\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/sqlity.net\" \/>\n<meta property=\"article:published_time\" content=\"2012-08-26T20:33:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2014-11-13T18:54:27+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/sqlity.net\/wp-content\/uploads\/2012\/08\/SQL_Server_replication_requires_the_actual_server_name_to_make_a_connection_to_the_server.jpg\" \/>\n<meta name=\"author\" content=\"Sebastian Meine\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@sqlity\" \/>\n<meta name=\"twitter:site\" content=\"@sqlity\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sebastian Meine\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/1084\\\/renaming-a-windows-machine-hosting-sql-server\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/1084\\\/renaming-a-windows-machine-hosting-sql-server\\\/\"},\"author\":{\"name\":\"Sebastian Meine\",\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/#\\\/schema\\\/person\\\/bcffd8c572bc2f1bd10fdba80135e53c\"},\"headline\":\"Renaming a Windows Machine hosting SQL Server\",\"datePublished\":\"2012-08-26T20:33:52+00:00\",\"dateModified\":\"2014-11-13T18:54:27+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/1084\\\/renaming-a-windows-machine-hosting-sql-server\\\/\"},\"wordCount\":483,\"commentCount\":2,\"image\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/1084\\\/renaming-a-windows-machine-hosting-sql-server\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/sqlity.net\\\/wp-content\\\/uploads\\\/2012\\\/08\\\/SQL_Server_replication_requires_the_actual_server_name_to_make_a_connection_to_the_server.jpg\",\"articleSection\":[\"General\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/sqlity.net\\\/en\\\/1084\\\/renaming-a-windows-machine-hosting-sql-server\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/1084\\\/renaming-a-windows-machine-hosting-sql-server\\\/\",\"url\":\"https:\\\/\\\/sqlity.net\\\/en\\\/1084\\\/renaming-a-windows-machine-hosting-sql-server\\\/\",\"name\":\"Renaming a Windows Machine hosting SQL Server - sqlity.net\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/1084\\\/renaming-a-windows-machine-hosting-sql-server\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/1084\\\/renaming-a-windows-machine-hosting-sql-server\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/sqlity.net\\\/wp-content\\\/uploads\\\/2012\\\/08\\\/SQL_Server_replication_requires_the_actual_server_name_to_make_a_connection_to_the_server.jpg\",\"datePublished\":\"2012-08-26T20:33:52+00:00\",\"dateModified\":\"2014-11-13T18:54:27+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/#\\\/schema\\\/person\\\/bcffd8c572bc2f1bd10fdba80135e53c\"},\"description\":\"Need to rename a computer hosting SQL Server? This post gives an automated solution for the changes required in every instance on the computer.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/1084\\\/renaming-a-windows-machine-hosting-sql-server\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/sqlity.net\\\/en\\\/1084\\\/renaming-a-windows-machine-hosting-sql-server\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/1084\\\/renaming-a-windows-machine-hosting-sql-server\\\/#primaryimage\",\"url\":\"http:\\\/\\\/sqlity.net\\\/wp-content\\\/uploads\\\/2012\\\/08\\\/SQL_Server_replication_requires_the_actual_server_name_to_make_a_connection_to_the_server.jpg\",\"contentUrl\":\"http:\\\/\\\/sqlity.net\\\/wp-content\\\/uploads\\\/2012\\\/08\\\/SQL_Server_replication_requires_the_actual_server_name_to_make_a_connection_to_the_server.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/1084\\\/renaming-a-windows-machine-hosting-sql-server\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/sqlity.net\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Renaming a Windows Machine hosting SQL Server\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/sqlity.net\\\/en\\\/\",\"name\":\"sqlity.net\",\"description\":\"Quality for SQL\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/sqlity.net\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/#\\\/schema\\\/person\\\/bcffd8c572bc2f1bd10fdba80135e53c\",\"name\":\"Sebastian Meine\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4ab0a6d02dd494849a584a2c3c8bc3bdcef1d0aa5f87e98bf905dbdb9ad2ce3a?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4ab0a6d02dd494849a584a2c3c8bc3bdcef1d0aa5f87e98bf905dbdb9ad2ce3a?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4ab0a6d02dd494849a584a2c3c8bc3bdcef1d0aa5f87e98bf905dbdb9ad2ce3a?s=96&d=mm&r=g\",\"caption\":\"Sebastian Meine\"},\"sameAs\":[\"http:\\\/\\\/sqlity.net\",\"https:\\\/\\\/x.com\\\/sqlity\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Renaming a Windows Machine hosting SQL Server - sqlity.net","description":"Need to rename a computer hosting SQL Server? This post gives an automated solution for the changes required in every instance on the computer.","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:\/\/sqlity.net\/en\/1084\/renaming-a-windows-machine-hosting-sql-server\/","og_locale":"en_US","og_type":"article","og_title":"Renaming a Windows Machine hosting SQL Server - sqlity.net","og_description":"Need to rename a computer hosting SQL Server? This post gives an automated solution for the changes required in every instance on the computer.","og_url":"https:\/\/sqlity.net\/en\/1084\/renaming-a-windows-machine-hosting-sql-server\/","og_site_name":"sqlity.net","article_publisher":"https:\/\/www.facebook.com\/sqlity.net","article_published_time":"2012-08-26T20:33:52+00:00","article_modified_time":"2014-11-13T18:54:27+00:00","og_image":[{"url":"http:\/\/sqlity.net\/wp-content\/uploads\/2012\/08\/SQL_Server_replication_requires_the_actual_server_name_to_make_a_connection_to_the_server.jpg","type":"","width":"","height":""}],"author":"Sebastian Meine","twitter_card":"summary_large_image","twitter_creator":"@sqlity","twitter_site":"@sqlity","twitter_misc":{"Written by":"Sebastian Meine","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/sqlity.net\/en\/1084\/renaming-a-windows-machine-hosting-sql-server\/#article","isPartOf":{"@id":"https:\/\/sqlity.net\/en\/1084\/renaming-a-windows-machine-hosting-sql-server\/"},"author":{"name":"Sebastian Meine","@id":"https:\/\/sqlity.net\/en\/#\/schema\/person\/bcffd8c572bc2f1bd10fdba80135e53c"},"headline":"Renaming a Windows Machine hosting SQL Server","datePublished":"2012-08-26T20:33:52+00:00","dateModified":"2014-11-13T18:54:27+00:00","mainEntityOfPage":{"@id":"https:\/\/sqlity.net\/en\/1084\/renaming-a-windows-machine-hosting-sql-server\/"},"wordCount":483,"commentCount":2,"image":{"@id":"https:\/\/sqlity.net\/en\/1084\/renaming-a-windows-machine-hosting-sql-server\/#primaryimage"},"thumbnailUrl":"http:\/\/sqlity.net\/wp-content\/uploads\/2012\/08\/SQL_Server_replication_requires_the_actual_server_name_to_make_a_connection_to_the_server.jpg","articleSection":["General"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/sqlity.net\/en\/1084\/renaming-a-windows-machine-hosting-sql-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sqlity.net\/en\/1084\/renaming-a-windows-machine-hosting-sql-server\/","url":"https:\/\/sqlity.net\/en\/1084\/renaming-a-windows-machine-hosting-sql-server\/","name":"Renaming a Windows Machine hosting SQL Server - sqlity.net","isPartOf":{"@id":"https:\/\/sqlity.net\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sqlity.net\/en\/1084\/renaming-a-windows-machine-hosting-sql-server\/#primaryimage"},"image":{"@id":"https:\/\/sqlity.net\/en\/1084\/renaming-a-windows-machine-hosting-sql-server\/#primaryimage"},"thumbnailUrl":"http:\/\/sqlity.net\/wp-content\/uploads\/2012\/08\/SQL_Server_replication_requires_the_actual_server_name_to_make_a_connection_to_the_server.jpg","datePublished":"2012-08-26T20:33:52+00:00","dateModified":"2014-11-13T18:54:27+00:00","author":{"@id":"https:\/\/sqlity.net\/en\/#\/schema\/person\/bcffd8c572bc2f1bd10fdba80135e53c"},"description":"Need to rename a computer hosting SQL Server? This post gives an automated solution for the changes required in every instance on the computer.","breadcrumb":{"@id":"https:\/\/sqlity.net\/en\/1084\/renaming-a-windows-machine-hosting-sql-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sqlity.net\/en\/1084\/renaming-a-windows-machine-hosting-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/sqlity.net\/en\/1084\/renaming-a-windows-machine-hosting-sql-server\/#primaryimage","url":"http:\/\/sqlity.net\/wp-content\/uploads\/2012\/08\/SQL_Server_replication_requires_the_actual_server_name_to_make_a_connection_to_the_server.jpg","contentUrl":"http:\/\/sqlity.net\/wp-content\/uploads\/2012\/08\/SQL_Server_replication_requires_the_actual_server_name_to_make_a_connection_to_the_server.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/sqlity.net\/en\/1084\/renaming-a-windows-machine-hosting-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sqlity.net\/en\/"},{"@type":"ListItem","position":2,"name":"Renaming a Windows Machine hosting SQL Server"}]},{"@type":"WebSite","@id":"https:\/\/sqlity.net\/en\/#website","url":"https:\/\/sqlity.net\/en\/","name":"sqlity.net","description":"Quality for SQL","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/sqlity.net\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/sqlity.net\/en\/#\/schema\/person\/bcffd8c572bc2f1bd10fdba80135e53c","name":"Sebastian Meine","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/4ab0a6d02dd494849a584a2c3c8bc3bdcef1d0aa5f87e98bf905dbdb9ad2ce3a?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/4ab0a6d02dd494849a584a2c3c8bc3bdcef1d0aa5f87e98bf905dbdb9ad2ce3a?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4ab0a6d02dd494849a584a2c3c8bc3bdcef1d0aa5f87e98bf905dbdb9ad2ce3a?s=96&d=mm&r=g","caption":"Sebastian Meine"},"sameAs":["http:\/\/sqlity.net","https:\/\/x.com\/sqlity"]}]}},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2wXuw-hu","jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/posts\/1084","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/comments?post=1084"}],"version-history":[{"count":0,"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/posts\/1084\/revisions"}],"wp:attachment":[{"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/media?parent=1084"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/categories?post=1084"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/tags?post=1084"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}