{"id":210,"date":"2007-06-19T12:50:00","date_gmt":"2007-06-19T12:50:00","guid":{"rendered":"https:\/\/brainlitter.itgroove.net\/2007\/06\/19\/rename-a-sql-2000-or-2005-server\/"},"modified":"2007-06-19T12:50:00","modified_gmt":"2007-06-19T12:50:00","slug":"rename-a-sql-2000-or-2005-server","status":"publish","type":"post","link":"https:\/\/regroove.ca\/brainlitter\/2007\/06\/19\/rename-a-sql-2000-or-2005-server\/","title":{"rendered":"Rename a SQL 2000 or 2005 Server"},"content":{"rendered":"
\n

I’ve had to do this on occasion and it was worth bookmarking. As well, there is more to considering renaming a SQL Server than just SQL or Windows.<\/p><\/blockquote>\n

If you just rename a SQL Server, SQL will bitch … so here are the basics to be done … (as well as checking logs, modifying backups, modifying antivirus clients and accounting for any other application\/software that might be installed on the machine) – ie. there is a significant amount of ‘other’ things that will need attention besides SQL and the name change.<\/p>\n

1. Ensure you have a recent and FULL backup of the server and SQL
2. Rename Server (follow appropriate naming rules and considerations for Active Directory)
3. After you change the server name and reboot SQL Server will automatically detect that you’ve changed the server name and then fix itself”. All you’ll have to do is connect to the new server name in Query Analyzer and run the following command:
— sp_dropserver ‘old server name’
— sp_addserver ‘new server name’, ‘local’
4. Finally, delete the entry in Enterprise Manager for the old server name and add in the new server
5. Turn 360 degrees to the left, do two deep knee bends and shout ‘Yoko killed the Beatles’ 3 times<\/p>\n

Some reference materials and gotchas (besides AV, backups, etc.) to consider:
— Microsoft Technote for renaming SQL 2005 – same procedure applies for SQL 2000 – http:\/\/msdn2.microsoft.com\/en-us\/library\/ms143799(SQL.90).aspx<\/a>
— Knowledge base references – http:\/\/support.microsoft.com\/kb\/303774\/en-us<\/a>, http:\/\/support.microsoft.com\/kb\/281642\/en-us<\/a>, http:\/\/support.microsoft.com\/kb\/317241\/en-us<\/a><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

I’ve had to do this on occasion and it was worth bookmarking. As well, there is more to considering renaming a SQL Server than just SQL or Windows. If you just rename a SQL Server, SQL will bitch … so here are the basics to be done … (as well as checking logs, modifying backups, … <\/a><\/p>\n","protected":false},"author":10,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":"","_jetpack_memberships_contains_paid_content":false},"categories":[189],"tags":[],"acf":[],"yoast_head":"\nRename a SQL 2000 or 2005 Server - Brainlitter - Inside the mind of Sean Wallbridge<\/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:\/\/regroove.ca\/brainlitter\/2007\/06\/19\/rename-a-sql-2000-or-2005-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Rename a SQL 2000 or 2005 Server - Brainlitter - Inside the mind of Sean Wallbridge\" \/>\n<meta property=\"og:description\" content=\"I’ve had to do this on occasion and it was worth bookmarking. As well, there is more to considering renaming a SQL Server than just SQL or Windows. If you just rename a SQL Server, SQL will bitch … so here are the basics to be done … (as well as checking logs, modifying backups, …\" \/>\n<meta property=\"og:url\" content=\"https:\/\/regroove.ca\/brainlitter\/2007\/06\/19\/rename-a-sql-2000-or-2005-server\/\" \/>\n<meta property=\"og:site_name\" content=\"Brainlitter - Inside the mind of Sean Wallbridge\" \/>\n<meta property=\"article:published_time\" content=\"2007-06-19T12:50:00+00:00\" \/>\n<meta name=\"author\" content=\"Sean Wallbridge\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sean Wallbridge\" \/>\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\":\"WebPage\",\"@id\":\"https:\/\/regroove.ca\/brainlitter\/2007\/06\/19\/rename-a-sql-2000-or-2005-server\/\",\"url\":\"https:\/\/regroove.ca\/brainlitter\/2007\/06\/19\/rename-a-sql-2000-or-2005-server\/\",\"name\":\"Rename a SQL 2000 or 2005 Server - Brainlitter - Inside the mind of Sean Wallbridge\",\"isPartOf\":{\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#website\"},\"datePublished\":\"2007-06-19T12:50:00+00:00\",\"dateModified\":\"2007-06-19T12:50:00+00:00\",\"author\":{\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/74e1c0def190f181c1394c2b6d883e77\"},\"breadcrumb\":{\"@id\":\"https:\/\/regroove.ca\/brainlitter\/2007\/06\/19\/rename-a-sql-2000-or-2005-server\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/regroove.ca\/brainlitter\/2007\/06\/19\/rename-a-sql-2000-or-2005-server\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/regroove.ca\/brainlitter\/2007\/06\/19\/rename-a-sql-2000-or-2005-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Brainlitter\",\"item\":\"https:\/\/regroove.ca\/brainlitter\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Rename a SQL 2000 or 2005 Server\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#website\",\"url\":\"https:\/\/regroove.ca\/brainlitter\/\",\"name\":\"Brainlitter - Inside the mind of Sean Wallbridge\",\"description\":\"Dad. Husband. Drummer. Learner of Things.\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/regroove.ca\/brainlitter\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/74e1c0def190f181c1394c2b6d883e77\",\"name\":\"Sean Wallbridge\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/adf8cea6291c39d166616f2148d919a6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/adf8cea6291c39d166616f2148d919a6?s=96&d=mm&r=g\",\"caption\":\"Sean Wallbridge\"},\"url\":\"https:\/\/regroove.ca\/brainlitter\/author\/swallbridge\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Rename a SQL 2000 or 2005 Server - Brainlitter - Inside the mind of Sean Wallbridge","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:\/\/regroove.ca\/brainlitter\/2007\/06\/19\/rename-a-sql-2000-or-2005-server\/","og_locale":"en_US","og_type":"article","og_title":"Rename a SQL 2000 or 2005 Server - Brainlitter - Inside the mind of Sean Wallbridge","og_description":"I’ve had to do this on occasion and it was worth bookmarking. As well, there is more to considering renaming a SQL Server than just SQL or Windows. If you just rename a SQL Server, SQL will bitch … so here are the basics to be done … (as well as checking logs, modifying backups, …","og_url":"https:\/\/regroove.ca\/brainlitter\/2007\/06\/19\/rename-a-sql-2000-or-2005-server\/","og_site_name":"Brainlitter - Inside the mind of Sean Wallbridge","article_published_time":"2007-06-19T12:50:00+00:00","author":"Sean Wallbridge","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Sean Wallbridge","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/regroove.ca\/brainlitter\/2007\/06\/19\/rename-a-sql-2000-or-2005-server\/","url":"https:\/\/regroove.ca\/brainlitter\/2007\/06\/19\/rename-a-sql-2000-or-2005-server\/","name":"Rename a SQL 2000 or 2005 Server - Brainlitter - Inside the mind of Sean Wallbridge","isPartOf":{"@id":"https:\/\/regroove.ca\/brainlitter\/#website"},"datePublished":"2007-06-19T12:50:00+00:00","dateModified":"2007-06-19T12:50:00+00:00","author":{"@id":"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/74e1c0def190f181c1394c2b6d883e77"},"breadcrumb":{"@id":"https:\/\/regroove.ca\/brainlitter\/2007\/06\/19\/rename-a-sql-2000-or-2005-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/regroove.ca\/brainlitter\/2007\/06\/19\/rename-a-sql-2000-or-2005-server\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/regroove.ca\/brainlitter\/2007\/06\/19\/rename-a-sql-2000-or-2005-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Brainlitter","item":"https:\/\/regroove.ca\/brainlitter\/"},{"@type":"ListItem","position":2,"name":"Rename a SQL 2000 or 2005 Server"}]},{"@type":"WebSite","@id":"https:\/\/regroove.ca\/brainlitter\/#website","url":"https:\/\/regroove.ca\/brainlitter\/","name":"Brainlitter - Inside the mind of Sean Wallbridge","description":"Dad. Husband. Drummer. Learner of Things.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/regroove.ca\/brainlitter\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/74e1c0def190f181c1394c2b6d883e77","name":"Sean Wallbridge","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/adf8cea6291c39d166616f2148d919a6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/adf8cea6291c39d166616f2148d919a6?s=96&d=mm&r=g","caption":"Sean Wallbridge"},"url":"https:\/\/regroove.ca\/brainlitter\/author\/swallbridge\/"}]}},"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/posts\/210"}],"collection":[{"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/comments?post=210"}],"version-history":[{"count":0,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/posts\/210\/revisions"}],"wp:attachment":[{"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/media?parent=210"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/categories?post=210"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/tags?post=210"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}