{"id":349,"date":"2013-10-01T23:47:33","date_gmt":"2013-10-01T23:47:33","guid":{"rendered":"http:\/\/www.theSQLReport.com\/?p=349"},"modified":"2014-02-14T20:51:00","modified_gmt":"2014-02-14T20:51:00","slug":"upgrade-sql-server-2012-standard-to-enterprise","status":"publish","type":"post","link":"https:\/\/www.theSQLReport.com\/?p=349","title":{"rendered":"Upgrade SQL Server 2012 Standard to Enterprise"},"content":{"rendered":"<p style=\"text-align: left;\">This blog is about upgrading SQL Server 2012 Standard Edition to the Enterprise Edition. This issue has been written about a couple of times, but one more blog about this subject with a couple of screen shots will not hurt.<\/p>\n<p style=\"text-align: left;\">First, verify which edition of SQL Server you are running is by running &#8220;SELECT @@VERSION&#8221; in a SSMS query window.<\/p>\n<p style=\"text-align: left;\"><a href=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2013\/09\/upgrade001.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-390\" alt=\"Standard Version Check\" src=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2013\/09\/upgrade001.jpg\" width=\"405\" height=\"251\" srcset=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2013\/09\/upgrade001.jpg 405w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2013\/09\/upgrade001-300x185.jpg 300w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2013\/09\/upgrade001-210x130.jpg 210w\" sizes=\"(max-width: 405px) 100vw, 405px\" \/><\/a><\/p>\n<p style=\"text-align: left;\">Start the SQL Server 2012 Enterprise (DVD\/ISO).\u00a0 When the SQL Server Installation Center app appears, click on the \u201cMaintenance\u201d link on the top left panel of the app.<\/p>\n<p style=\"text-align: left;\"><a href=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2013\/09\/upgrade002.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-391\" alt=\"Maintenance Link\" src=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2013\/09\/upgrade002.jpg\" width=\"532\" height=\"288\" srcset=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2013\/09\/upgrade002.jpg 532w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2013\/09\/upgrade002-300x162.jpg 300w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2013\/09\/upgrade002-210x113.jpg 210w\" sizes=\"(max-width: 532px) 100vw, 532px\" \/><\/a><\/p>\n<p style=\"text-align: left;\">Then at the top of the right panel of the SQL Server Installation Center app, click on the \u201cEdition Upgrade\u201d link.<\/p>\n<p style=\"text-align: left;\"><a href=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2013\/09\/upgrade003.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-392\" alt=\"Edition Upgrade Link\" src=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2013\/09\/upgrade003.jpg\" width=\"801\" height=\"202\" \/><\/a><\/p>\n<p style=\"text-align: left;\">A new app box will appear.\u00a0 This app will do a scan for \u201cSetup Support Rules\u201d.\u00a0 If this scan succeeds, then click the OK button in the bottom right corner of the app.<\/p>\n<p style=\"text-align: left;\"><a href=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2013\/09\/upgrade004.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-393\" alt=\"Rules Scan\" src=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2013\/09\/upgrade004.jpg\" width=\"817\" height=\"613\" srcset=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2013\/09\/upgrade004.jpg 817w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2013\/09\/upgrade004-300x225.jpg 300w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2013\/09\/upgrade004-210x157.jpg 210w\" sizes=\"(max-width: 817px) 100vw, 817px\" \/><\/a><\/p>\n<p style=\"text-align: left;\">The app will disappear, the there may appear a couple of pop up boxes that will disappear each on its own.<\/p>\n<p style=\"text-align: left;\"><a href=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2013\/09\/upgrade005.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-394\" alt=\"Pop Up in Progress\" src=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2013\/09\/upgrade005.jpg\" width=\"550\" height=\"104\" srcset=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2013\/09\/upgrade005.jpg 550w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2013\/09\/upgrade005-300x56.jpg 300w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2013\/09\/upgrade005-210x39.jpg 210w\" sizes=\"(max-width: 550px) 100vw, 550px\" \/><\/a><\/p>\n<p style=\"text-align: left;\">The \u201cUpgrade the Edition for SQL Server 2012\u201d app will appear.\u00a0 This will perform a scan for the \u201cSetup Support Rules\u201d.\u00a0 A different scan then the one performed before.\u00a0 Click the NEXT button when the scan has completed.<\/p>\n<p style=\"text-align: left;\"><a href=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2013\/09\/upgrade006.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-395\" alt=\"Setup Support Rules Scan\" src=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2013\/09\/upgrade006.jpg\" width=\"815\" height=\"610\" srcset=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2013\/09\/upgrade006.jpg 815w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2013\/09\/upgrade006-300x224.jpg 300w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2013\/09\/upgrade006-210x157.jpg 210w\" sizes=\"(max-width: 815px) 100vw, 815px\" \/><\/a><\/p>\n<p style=\"text-align: left;\">The next screen is the Product Key screen.\u00a0 Enter your product key, if it does not auto fill the \u201cEnter the product key:\u201d text box.\u00a0 Then click the NEXT button.<\/p>\n<p style=\"text-align: left;\"><a href=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2013\/09\/upgrade007.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-396\" alt=\"Product Key screen\" src=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2013\/09\/upgrade007.jpg\" width=\"819\" height=\"613\" srcset=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2013\/09\/upgrade007.jpg 819w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2013\/09\/upgrade007-300x224.jpg 300w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2013\/09\/upgrade007-210x157.jpg 210w\" sizes=\"(max-width: 819px) 100vw, 819px\" \/><\/a><\/p>\n<p style=\"text-align: left;\">The next screen is the License Term screen.\u00a0 Click the \u201cI accept the license terms\u201d check box.\u00a0 Then click on the NEXT button.<\/p>\n<p style=\"text-align: left;\"><a href=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2013\/09\/LicenseTerms01.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-409\" alt=\"LicenseTerms01\" src=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2013\/09\/LicenseTerms01.jpg\" width=\"820\" height=\"613\" srcset=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2013\/09\/LicenseTerms01.jpg 820w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2013\/09\/LicenseTerms01-300x224.jpg 300w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2013\/09\/LicenseTerms01-210x156.jpg 210w\" sizes=\"(max-width: 820px) 100vw, 820px\" \/><\/a><\/p>\n<p>The next is the Select Instance screen.\u00a0 Drop the combo box down to select the instance that you wish to upgrade.\u00a0 A list of recognized instances will be list in the Installed instances grid box.\u00a0 Then click on the NEXT button.\u00a0 A please wait box may appear for a couple of seconds.<\/p>\n<p><a href=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2013\/09\/SelectInstance01.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-410\" alt=\"SelectInstance01\" src=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2013\/09\/SelectInstance01.jpg\" width=\"820\" height=\"613\" srcset=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2013\/09\/SelectInstance01.jpg 820w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2013\/09\/SelectInstance01-300x224.jpg 300w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2013\/09\/SelectInstance01-210x156.jpg 210w\" sizes=\"(max-width: 820px) 100vw, 820px\" \/><\/a><\/p>\n<p>The Edition Upgrade Rules screen appears next.\u00a0 A scan will run to validate the edition upgrade process.\u00a0 Once the scan is completed, click the NEXT button.<\/p>\n<p><a href=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2013\/09\/upgrade008.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-397\" alt=\"Upgrade Rules Scan\" src=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2013\/09\/upgrade008.jpg\" width=\"817\" height=\"611\" srcset=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2013\/09\/upgrade008.jpg 817w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2013\/09\/upgrade008-300x224.jpg 300w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2013\/09\/upgrade008-210x157.jpg 210w\" sizes=\"(max-width: 817px) 100vw, 817px\" \/><\/a><\/p>\n<p>The Ready to upgrade edition screen appears next.\u00a0 In the text box will appear a list of item that are going to be upgraded.\u00a0 After reviewing this list, click on the UPGRADE button.<\/p>\n<p><a href=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2013\/09\/upgrade009.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-398\" alt=\"upgrade009\" src=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2013\/09\/upgrade009.jpg\" width=\"817\" height=\"615\" srcset=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2013\/09\/upgrade009.jpg 817w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2013\/09\/upgrade009-300x225.jpg 300w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2013\/09\/upgrade009-210x158.jpg 210w\" sizes=\"(max-width: 817px) 100vw, 817px\" \/><\/a><\/p>\n<p>Once the UPGRADE button has been clicked, it will grey out.\u00a0 Then nothing will happen for maybe a minute.\u00a0 Then the Complete screen if the upgrade has succeed.\u00a0 Click the CLOSE button.<\/p>\n<p><a href=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2013\/09\/upgrade010.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-399\" alt=\"upgrade010\" src=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2013\/09\/upgrade010.jpg\" width=\"819\" height=\"613\" srcset=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2013\/09\/upgrade010.jpg 819w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2013\/09\/upgrade010-300x224.jpg 300w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2013\/09\/upgrade010-210x157.jpg 210w\" sizes=\"(max-width: 819px) 100vw, 819px\" \/><\/a><\/p>\n<p>Close the \u201cSQL Server Installation Center\u201d app, by click the X box in the top right hand corner.<\/p>\n<p>Verify that SQL Server has upgraded by running the \u201cSELECT @@VERSION\u201d in a SSMS query window.<\/p>\n<p><a href=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2013\/09\/upgrade011.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-400\" alt=\"upgrade011\" src=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2013\/09\/upgrade011.jpg\" width=\"422\" height=\"314\" srcset=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2013\/09\/upgrade011.jpg 422w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2013\/09\/upgrade011-300x223.jpg 300w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2013\/09\/upgrade011-210x156.jpg 210w\" sizes=\"(max-width: 422px) 100vw, 422px\" \/><\/a><\/p>\n<p>Final Note: To the best of my knowledge, no reboot is required after the upgrade is finished. \u00a0I have ran a test on each SQL 2008R2 &amp; SQL 2012.\u00a0 Both did not require a reboot.\u00a0 This was on a Server 2008R2 operating system.\u00a0 Please test before attempting this in a production environment.<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This blog is about upgrading SQL Server 2012 Standard Edition to the Enterprise Edition. This issue has been written about a couple of times, but one more blog about this &hellip; <a class=\"readmore\" href=\"https:\/\/www.theSQLReport.com\/?p=349\">Continue Reading &rarr;<\/a><\/p>\n","protected":false},"author":1,"featured_media":392,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-349","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sql-server"],"_links":{"self":[{"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts\/349"}],"collection":[{"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=349"}],"version-history":[{"count":15,"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts\/349\/revisions"}],"predecessor-version":[{"id":574,"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts\/349\/revisions\/574"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/media\/392"}],"wp:attachment":[{"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=349"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=349"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=349"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}