{"id":8029,"date":"2016-05-20T08:45:21","date_gmt":"2016-05-20T06:45:21","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/sql-server-2005-decommissioning-failed\/"},"modified":"2016-05-20T08:45:21","modified_gmt":"2016-05-20T06:45:21","slug":"sql-server-2005-decommissioning-failed","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sql-server-2005-decommissioning-failed\/","title":{"rendered":"SQL Server 2005 decommissioning failed!"},"content":{"rendered":"

The support for SQL Server 2005 is no more available<\/a>, so we are migrating all the latest databases running under SQL Server 2005 to SQL server 2012 or higher!
\nLast time, I had to uninstall an old SQL Server 2005 clustered instance in a 64 bits architecture on Windows Server 2008R2.
\nIn fact, this clustered environment contains many other instances (either SQL Server 2005 or 2008 R2).<\/p>\n

But during the uninstallation, an error happened\u2026.
\nFirst, the event viewer informed me about this error:<\/p>\n

Microsoft SQL Server 2005 (64-bit) — Error 29530. Failed to set registry settings for server network libraries. The action is SetShilohRoot. The error is 2 (The system cannot find the file specified).<\/p>\n

As many people, I \u201cgoogled\u201d the error 29530 and saw this discussion on the msdn forum here<\/a><\/p>\n

I tried these solutions to resolve my issue but I still had the same error… \u2639
\nThen I analyzed the summary.txt<\/strong> from the uninstallation in the folder C:Program FilesMicrosoft SQL Server90Setup BootstrapLOG<\/strong> to see if I had more information about the uninstallation problem.
\nIn the file, I read this error:<\/p>\n

Microsoft SQL Server 2005 9.00.5000.00
\n==============================
\nOS Version\u00a0\u00a0\u00a0\u00a0\u00a0 : Server 4.0, Enterprise Edition Service Pack 1 (Build 7601)
\nTime\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : Tue May 03 21:34:59 2016
\nNode01: Failed to find the ASP.Net Version Registration with Microsoft Internet Information Services (IIS).
\nMachine\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : Node01
\nProduct\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : SQL Server Database Services
\nError\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : The setup has encountered an unexpected error while Completing Commit. The error is: The cluster resource could not be found.
\n——————————————————————————–
\nMachine\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : Node01
\nProduct\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : SQL Server Database Services
\nError\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : Failed to set registry settings for server network libraries. The action is SetShilohRoot. The error is 2 (The system cannot find the file specified.)
\n——————————————————————————–
\nMachine\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 :Node01
\nProduct\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : Microsoft SQL Server 2005 (64-bit)
\nProduct Version : 9.00.1399.06
\nUninstall\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : Failed
\nLog File\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : \\Node02C$Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0016_node01_SQL.log
\nLast Action\u00a0\u00a0\u00a0\u00a0 : InstallFinalize
\nError String\u00a0\u00a0\u00a0 : The setup has encountered an unexpected error while Completing Commit. The error is: The cluster resource could not be found.
\nError Number\u00a0\u00a0\u00a0 : 29528
\n——————————————————————————–
\nSQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt.
\nTime\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : Tue May 03 21:37:14 2016
\nList of log files:
\nC:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0016_node02_Core(Local).log
\nC:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0016_node02_Datastore.xml
\nC:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0016_node02_.NET Framework 2.0.log
\nC:Program FilesMicrosoft SQL Server90Setup BootstrapLOGSummary.txt
\nC:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0016_node02_SCC.log
\nC:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0016_node02_WI.log
\n\\node02C$Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0016_node01_Logs.cab<\/em><\/p>\n

The important information was this log:
\n<\/em><\/p>\n

Node01: Failed to find the ASP.Net Version Registration with Microsoft Internet Information Services<\/em><\/strong><\/p>\n

It was very strange, Reporting Services was not installed but IIS had to be installed to continue the uninstallation process.
\nPerhaps, we needed to reactivate IIS or register again the component on both nodes:
\nhttp:\/\/www.windowstechupdates.com\/asp-net-version-registration-requirement-during-installation\/<\/a><\/p>\n

And it was the only way to do the uninstall\u2026 NO!<\/strong><\/p>\n

Finally, the problem was totally different\u2026 A simple permission problem!
\nThe login was “domain admin” and also “local admin” on both nodes but apparently it is not enough\u2026
\nOn Windows Server 2008R2, the \u201cControl Panel > Programs and Features\u201d needed to be run as administrator!<\/p>\n

The solution is very simple but hard to find \ud83d\ude09 :
\n1. Run the command prompt as Administrator<\/strong>
\n 2. Enter appwiz.cpl (Programs and Features command)<\/strong>
\n 3. Run the uninstall of SQL Server 2005<\/strong><\/p>\n

Et voil\u00e0! To conclude, this is one the most experience for a decommissioning of SQL Server 2005.
\nDon\u2019t hesitate to come to dbi services to help you to migrate to SQL Server 2012, 2014 and soon 2016!<\/p>\n","protected":false},"excerpt":{"rendered":"

The support for SQL Server 2005 is no more available, so we are migrating all the latest databases running under SQL Server 2005 to SQL server 2012 or higher! Last time, I had to uninstall an old SQL Server 2005 clustered instance in a 64 bits architecture on Windows Server 2008R2. In fact, this clustered […]<\/p>\n","protected":false},"author":15,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[198],"tags":[49,15,51],"type_dbi":[],"class_list":["post-8029","post","type-post","status-publish","format-standard","hentry","category-database-management","tag-microsoft","tag-migration","tag-sql-server"],"acf":[],"yoast_head":"\nSQL Server 2005 decommissioning failed! - dbi Blog<\/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.dbi-services.com\/blog\/sql-server-2005-decommissioning-failed\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server 2005 decommissioning failed!\" \/>\n<meta property=\"og:description\" content=\"The support for SQL Server 2005 is no more available, so we are migrating all the latest databases running under SQL Server 2005 to SQL server 2012 or higher! Last time, I had to uninstall an old SQL Server 2005 clustered instance in a 64 bits architecture on Windows Server 2008R2. In fact, this clustered […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sql-server-2005-decommissioning-failed\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2016-05-20T06:45:21+00:00\" \/>\n<meta name=\"author\" content=\"St\u00e9phane Haby\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"St\u00e9phane Haby\" \/>\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.dbi-services.com\/blog\/sql-server-2005-decommissioning-failed\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2005-decommissioning-failed\/\"},\"author\":{\"name\":\"St\u00e9phane Haby\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b\"},\"headline\":\"SQL Server 2005 decommissioning failed!\",\"datePublished\":\"2016-05-20T06:45:21+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2005-decommissioning-failed\/\"},\"wordCount\":595,\"commentCount\":0,\"keywords\":[\"Microsoft\",\"Migration\",\"SQL Server\"],\"articleSection\":[\"Database management\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-2005-decommissioning-failed\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2005-decommissioning-failed\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2005-decommissioning-failed\/\",\"name\":\"SQL Server 2005 decommissioning failed! - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2016-05-20T06:45:21+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2005-decommissioning-failed\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-2005-decommissioning-failed\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2005-decommissioning-failed\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server 2005 decommissioning failed!\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b\",\"name\":\"St\u00e9phane Haby\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"caption\":\"St\u00e9phane Haby\"},\"description\":\"St\u00e9phane Haby has more than ten years of experience in Microsoft solutions. He is specialized in SQL Server technologies such as installation, migration, best practices, and performance analysis etc. He is also an expert in Microsoft Business Intelligence solutions such as SharePoint, SQL Server and Office. Futhermore, he has many years of .NET development experience in the banking sector and other industries. In France, he was one of the first people to have worked with Microsoft Team System. He has written several technical articles on this subject. St\u00e9phane Haby is Microsoft Most Valuable Professional (MVP) as well as Microsoft Certified Solutions Associate (MCSA) and\u00a0Microsoft Certified Solutions Expert (MCSE) for SQL Server 2012. He is also Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008 as well as ITIL Foundation V3 certified. He holds a Engineer diploma in industrial computing and automation from France. His branch-related experience covers Chemicals & Pharmaceuticals, Banking \/ Financial Services, and many other industries.\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/stephane-haby\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL Server 2005 decommissioning failed! - dbi Blog","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.dbi-services.com\/blog\/sql-server-2005-decommissioning-failed\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server 2005 decommissioning failed!","og_description":"The support for SQL Server 2005 is no more available, so we are migrating all the latest databases running under SQL Server 2005 to SQL server 2012 or higher! Last time, I had to uninstall an old SQL Server 2005 clustered instance in a 64 bits architecture on Windows Server 2008R2. In fact, this clustered […]","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2005-decommissioning-failed\/","og_site_name":"dbi Blog","article_published_time":"2016-05-20T06:45:21+00:00","author":"St\u00e9phane Haby","twitter_card":"summary_large_image","twitter_misc":{"Written by":"St\u00e9phane Haby","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2005-decommissioning-failed\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2005-decommissioning-failed\/"},"author":{"name":"St\u00e9phane Haby","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"headline":"SQL Server 2005 decommissioning failed!","datePublished":"2016-05-20T06:45:21+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2005-decommissioning-failed\/"},"wordCount":595,"commentCount":0,"keywords":["Microsoft","Migration","SQL Server"],"articleSection":["Database management"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2005-decommissioning-failed\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2005-decommissioning-failed\/","url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2005-decommissioning-failed\/","name":"SQL Server 2005 decommissioning failed! - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2016-05-20T06:45:21+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2005-decommissioning-failed\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2005-decommissioning-failed\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2005-decommissioning-failed\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server 2005 decommissioning failed!"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b","name":"St\u00e9phane Haby","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","caption":"St\u00e9phane Haby"},"description":"St\u00e9phane Haby has more than ten years of experience in Microsoft solutions. He is specialized in SQL Server technologies such as installation, migration, best practices, and performance analysis etc. He is also an expert in Microsoft Business Intelligence solutions such as SharePoint, SQL Server and Office. Futhermore, he has many years of .NET development experience in the banking sector and other industries. In France, he was one of the first people to have worked with Microsoft Team System. He has written several technical articles on this subject. St\u00e9phane Haby is Microsoft Most Valuable Professional (MVP) as well as Microsoft Certified Solutions Associate (MCSA) and\u00a0Microsoft Certified Solutions Expert (MCSE) for SQL Server 2012. He is also Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008 as well as ITIL Foundation V3 certified. He holds a Engineer diploma in industrial computing and automation from France. His branch-related experience covers Chemicals & Pharmaceuticals, Banking \/ Financial Services, and many other industries.","url":"https:\/\/www.dbi-services.com\/blog\/author\/stephane-haby\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/8029","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/15"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=8029"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/8029\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=8029"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=8029"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=8029"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=8029"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}