{"id":632,"date":"2010-04-22T23:54:00","date_gmt":"2010-04-22T23:54:00","guid":{"rendered":"https:\/\/brainlitter.itgroove.net\/2010\/04\/22\/upgrading-sql-server-2008-enterprise-evaluation-to-a-licensed-standard-edition\/"},"modified":"2010-04-22T23:54:00","modified_gmt":"2010-04-22T23:54:00","slug":"upgrading-sql-server-2008-enterprise-evaluation-to-a-licensed-standard-edition","status":"publish","type":"post","link":"https:\/\/regroove.ca\/brainlitter\/2010\/04\/22\/upgrading-sql-server-2008-enterprise-evaluation-to-a-licensed-standard-edition\/","title":{"rendered":"Upgrading SQL Server 2008 Enterprise Evaluation to a Licensed Standard Edition"},"content":{"rendered":"<div class=\"ExternalClassAB9815118C904489BBB4E084ED8435C8\">\n<p><span style=\"font-size:12pt\">Ok, first off, the title is an oxymoron. This is a <em>downgrade<\/em>. <\/span><\/p>\n<p>\u00a0<\/p>\n<p><span style=\"font-size:12pt\">Customers end up in this situation because they downloaded a SQL Server Evaluation and Microsoft only provides SQL in the &#8216;Enterprise Edition&#8217; format. <\/span><\/p>\n<p>\u00a0<\/p>\n<p><span style=\"font-size:12pt\">Second, SQL Server 2008 is the *FIRST* SQL Server version to support this. Reference: <span style=\"color:#76923c;text-decoration:underline\">http:\/\/msdn.microsoft.com\/en-us\/library\/ms143393.aspx <\/span><\/span><\/p>\n<p>\u00a0<\/p>\n<h2>The Procedure: <\/h2>\n<p style=\"margin-left:36pt\"><span style=\"font-size:12pt\">1. After providing the correct media (if Volume, etc. there is no license key, just provide valid media for setup) <\/span><\/p>\n<p style=\"margin-left:36pt\"><span style=\"font-size:12pt\">2. For each instance that you need to &#8220;upgrade&#8221;, perform the following (make sure you are in the appropriate path): <\/span><\/p>\n<p>\u00a0<\/p>\n<p><span style=\"font-family:Courier New;font-size:12pt\"><span style=\"color:#365f91\">Setup.exe \/q \/ACTION=editionupgrade \/INSTANCENAME=<\/span><span style=\"color:#943634\"><strong>MSSQLSERVER <\/strong><\/span><\/span><\/p>\n<p>\u00a0<\/p>\n<p>\u00a0<\/p>\n<p style=\"margin-left:36pt\"><span style=\"color:black;font-size:12pt\">3. Reboot (I just made this up, but I like to know for sure this &#8220;sticks&#8221; so a reboot now saves heartache a month from now\/later <\/span><\/p>\n<p>\u00a0<\/p>\n<p>\u00a0<\/p>\n<p><span style=\"color:black;font-size:12pt\">For our customer tonight for example, I had to run this twice. Once for a &#8220;SHAREPOINT&#8221; instance and once for the default instance (to which I simply did not specify a name for the instance. SharePoint didn&#8217;t like it at first (as SQL got stopped in the process, etc.) but after an IISRESET all returned to normal. By the way, there isn&#8217;t much feedback from the program, it just runs for a bit and then stops. <\/span><\/p>\n<p>\u00a0<\/p>\n<p>\u00a0<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"\/brainlitterarchive\/Lists\/Photos\/042310_0654_UpgradingSQ1.png\"><span style=\"color:black;font-size:12pt\"> <\/span><\/p>\n<p>\u00a0<\/p>\n<h2>Notes: <\/h2>\n<ul>\n<li><span style=\"font-size:12pt\"><span style=\"color:black\"><strong><em>EditionUpgrade<\/em><\/strong> Syntax can be found at: <\/span><span style=\"color:#76923c;text-decoration:underline\">http:\/\/msdn.microsoft.com\/en-us\/library\/ms144259.aspx<\/span><span style=\"color:black\"> <\/span><\/span><\/li>\n<li>\n<div><span style=\"color:black;font-size:12pt\">If the Evaluation period has expired, you will need to backdate the date on the computer if you want to keep SQL operational long enough to get a backup first using a database maintenance plan, etc. So, you&#8217;ll need to do the following: <\/span><\/div>\n<ul>\n<li>\n<div><span style=\"color:black;font-size:12pt\">Stop and Disable the Windows Time Service <\/span><\/div>\n<ul>\n<li><span style=\"color:black;font-size:12pt\">If you are running SQL as a Virtual Guest on VMWare or Hyper-V, go into their tools (for VMWare, this is the &#8216;VMWare Tools Icon in your tray&#8217; and tell it not to sync time with the local host, or it will keep flipping the time back <\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>\u00a0<\/p>\n<p style=\"margin-left:54pt\">\u00a0<\/p>\n<p style=\"margin-left:54pt\"><img decoding=\"async\" alt=\"\" src=\"\/brainlitterarchive\/Lists\/Photos\/042310_0654_UpgradingSQ2.png\"><span style=\"color:black;font-size:12pt\"> <\/span><\/p>\n<p>\u00a0<\/p>\n<ul style=\"margin-left:72pt\">\n<li><span style=\"color:black;font-size:12pt\">Manually roll the date back to a time that work <\/span><\/li>\n<\/ul>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Ok, first off, the title is an oxymoron. This is a downgrade. \u00a0 Customers end up in this situation because they downloaded a SQL Server Evaluation and Microsoft only provides SQL in the &#8216;Enterprise Edition&#8217; format. \u00a0 Second, SQL Server 2008 is the *FIRST* SQL Server version to support this. Reference: http:\/\/msdn.microsoft.com\/en-us\/library\/ms143393.aspx \u00a0 The Procedure: &hellip; <a href=\"https:\/\/regroove.ca\/brainlitter\/2010\/04\/22\/upgrading-sql-server-2008-enterprise-evaluation-to-a-licensed-standard-edition\/\"><\/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":[14,428],"tags":[],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.0 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Upgrading SQL Server 2008 Enterprise Evaluation to a Licensed Standard Edition - 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=\"http:\/\/regroove.ca\/brainlitter\/2010\/04\/22\/upgrading-sql-server-2008-enterprise-evaluation-to-a-licensed-standard-edition\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Upgrading SQL Server 2008 Enterprise Evaluation to a Licensed Standard Edition - Brainlitter - Inside the mind of Sean Wallbridge\" \/>\n<meta property=\"og:description\" content=\"Ok, first off, the title is an oxymoron. This is a downgrade. \u00a0 Customers end up in this situation because they downloaded a SQL Server Evaluation and Microsoft only provides SQL in the &#8216;Enterprise Edition&#8217; format. \u00a0 Second, SQL Server 2008 is the *FIRST* SQL Server version to support this. Reference: http:\/\/msdn.microsoft.com\/en-us\/library\/ms143393.aspx \u00a0 The Procedure: &hellip;\" \/>\n<meta property=\"og:url\" content=\"http:\/\/regroove.ca\/brainlitter\/2010\/04\/22\/upgrading-sql-server-2008-enterprise-evaluation-to-a-licensed-standard-edition\/\" \/>\n<meta property=\"og:site_name\" content=\"Brainlitter - Inside the mind of Sean Wallbridge\" \/>\n<meta property=\"article:published_time\" content=\"2010-04-22T23:54: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=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"http:\/\/regroove.ca\/brainlitter\/2010\/04\/22\/upgrading-sql-server-2008-enterprise-evaluation-to-a-licensed-standard-edition\/\",\"url\":\"http:\/\/regroove.ca\/brainlitter\/2010\/04\/22\/upgrading-sql-server-2008-enterprise-evaluation-to-a-licensed-standard-edition\/\",\"name\":\"Upgrading SQL Server 2008 Enterprise Evaluation to a Licensed Standard Edition - Brainlitter - Inside the mind of Sean Wallbridge\",\"isPartOf\":{\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#website\"},\"datePublished\":\"2010-04-22T23:54:00+00:00\",\"dateModified\":\"2010-04-22T23:54:00+00:00\",\"author\":{\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/74e1c0def190f181c1394c2b6d883e77\"},\"breadcrumb\":{\"@id\":\"http:\/\/regroove.ca\/brainlitter\/2010\/04\/22\/upgrading-sql-server-2008-enterprise-evaluation-to-a-licensed-standard-edition\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/regroove.ca\/brainlitter\/2010\/04\/22\/upgrading-sql-server-2008-enterprise-evaluation-to-a-licensed-standard-edition\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/regroove.ca\/brainlitter\/2010\/04\/22\/upgrading-sql-server-2008-enterprise-evaluation-to-a-licensed-standard-edition\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Brainlitter\",\"item\":\"https:\/\/regroove.ca\/brainlitter\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Upgrading SQL Server 2008 Enterprise Evaluation to a Licensed Standard Edition\"}]},{\"@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":"Upgrading SQL Server 2008 Enterprise Evaluation to a Licensed Standard Edition - 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":"http:\/\/regroove.ca\/brainlitter\/2010\/04\/22\/upgrading-sql-server-2008-enterprise-evaluation-to-a-licensed-standard-edition\/","og_locale":"en_US","og_type":"article","og_title":"Upgrading SQL Server 2008 Enterprise Evaluation to a Licensed Standard Edition - Brainlitter - Inside the mind of Sean Wallbridge","og_description":"Ok, first off, the title is an oxymoron. This is a downgrade. \u00a0 Customers end up in this situation because they downloaded a SQL Server Evaluation and Microsoft only provides SQL in the &#8216;Enterprise Edition&#8217; format. \u00a0 Second, SQL Server 2008 is the *FIRST* SQL Server version to support this. Reference: http:\/\/msdn.microsoft.com\/en-us\/library\/ms143393.aspx \u00a0 The Procedure: &hellip;","og_url":"http:\/\/regroove.ca\/brainlitter\/2010\/04\/22\/upgrading-sql-server-2008-enterprise-evaluation-to-a-licensed-standard-edition\/","og_site_name":"Brainlitter - Inside the mind of Sean Wallbridge","article_published_time":"2010-04-22T23:54:00+00:00","author":"Sean Wallbridge","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Sean Wallbridge","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"http:\/\/regroove.ca\/brainlitter\/2010\/04\/22\/upgrading-sql-server-2008-enterprise-evaluation-to-a-licensed-standard-edition\/","url":"http:\/\/regroove.ca\/brainlitter\/2010\/04\/22\/upgrading-sql-server-2008-enterprise-evaluation-to-a-licensed-standard-edition\/","name":"Upgrading SQL Server 2008 Enterprise Evaluation to a Licensed Standard Edition - Brainlitter - Inside the mind of Sean Wallbridge","isPartOf":{"@id":"https:\/\/regroove.ca\/brainlitter\/#website"},"datePublished":"2010-04-22T23:54:00+00:00","dateModified":"2010-04-22T23:54:00+00:00","author":{"@id":"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/74e1c0def190f181c1394c2b6d883e77"},"breadcrumb":{"@id":"http:\/\/regroove.ca\/brainlitter\/2010\/04\/22\/upgrading-sql-server-2008-enterprise-evaluation-to-a-licensed-standard-edition\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["http:\/\/regroove.ca\/brainlitter\/2010\/04\/22\/upgrading-sql-server-2008-enterprise-evaluation-to-a-licensed-standard-edition\/"]}]},{"@type":"BreadcrumbList","@id":"http:\/\/regroove.ca\/brainlitter\/2010\/04\/22\/upgrading-sql-server-2008-enterprise-evaluation-to-a-licensed-standard-edition\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Brainlitter","item":"https:\/\/regroove.ca\/brainlitter\/"},{"@type":"ListItem","position":2,"name":"Upgrading SQL Server 2008 Enterprise Evaluation to a Licensed Standard Edition"}]},{"@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\/632"}],"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=632"}],"version-history":[{"count":0,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/posts\/632\/revisions"}],"wp:attachment":[{"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/media?parent=632"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/categories?post=632"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/tags?post=632"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}