{"id":300,"date":"2011-07-04T18:47:46","date_gmt":"2011-07-04T13:47:46","guid":{"rendered":"http:\/\/kennywu.info\/?p=300"},"modified":"2011-07-04T18:47:46","modified_gmt":"2011-07-04T13:47:46","slug":"how-to-change-sql-server-instance-name","status":"publish","type":"post","link":"http:\/\/kennywu.info\/?p=300","title":{"rendered":"How to: change SQL server instance name"},"content":{"rendered":"<p>SQL server typically gets its instance name from underlining machine name when the SQL server was first installed. If the machine name has been changed, the SQL server instance name will be in-sync with network name. It could cause lots of wired behavior. If the following two command give you different name, then you better change your instance name.<br \/>\n<code>sp_helpserver<br \/>\nselect @@servername<br \/>\n<\/code><br \/>\nTo change instance name run this:<br \/>\n<code><br \/>\nsp_dropserver 'old_name'<br \/>\ngo<br \/>\nsp_addserver 'new_name','local'<br \/>\ngo<br \/>\n<\/code><br \/>\nThen restart the SQL server service.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>SQL server typically gets its instance name from underlining machine name when the SQL server was first installed. If the machine name has been changed, the SQL server instance name will be in-sync with network name. It could cause lots &hellip; <a href=\"http:\/\/kennywu.info\/?p=300\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-300","post","type-post","status-publish","format-standard","hentry","category-database"],"_links":{"self":[{"href":"http:\/\/kennywu.info\/index.php?rest_route=\/wp\/v2\/posts\/300","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/kennywu.info\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/kennywu.info\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/kennywu.info\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/kennywu.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=300"}],"version-history":[{"count":2,"href":"http:\/\/kennywu.info\/index.php?rest_route=\/wp\/v2\/posts\/300\/revisions"}],"predecessor-version":[{"id":302,"href":"http:\/\/kennywu.info\/index.php?rest_route=\/wp\/v2\/posts\/300\/revisions\/302"}],"wp:attachment":[{"href":"http:\/\/kennywu.info\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=300"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/kennywu.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=300"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/kennywu.info\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=300"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}