{"id":1029,"date":"2015-11-24T02:47:06","date_gmt":"2015-11-24T02:47:06","guid":{"rendered":"http:\/\/www.theSQLReport.com\/?p=1029"},"modified":"2016-04-16T12:51:45","modified_gmt":"2016-04-16T12:51:45","slug":"upgrade-sql-server-2014-standard-to-enterprise","status":"publish","type":"post","link":"https:\/\/www.theSQLReport.com\/?p=1029","title":{"rendered":"Upgrade SQL Server 2014 Standard to Enterprise"},"content":{"rendered":"

This blog is about upgrading SQL Server 2014 Standard Edition to the Enterprise Edition.\u00a0 This blog looks & sound much like my October 2013 post, “Upgrade SQL Server 2012 Standard to Enterprise<\/a>“.\u00a0 Basically I just updated the pictures.\u00a0\u00a0 The upgrading the version in SQL Server 2014 appears to be simpler then SQL Server 2012, which was not very hard.<\/p>\n

First, verify which edition of SQL Server you are running is by running \u201cSELECT @@VERSION\u201d in a SSMS query window.<\/p>\n

\"Standard<\/a><\/p>\n

Start the SQL Server 2014 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

\"Click<\/a><\/p>\n

Then at the top of the right panel of the SQL Server Installation Center app, click on the \u201cEdition Upgrade\u201d link.<\/p>\n

\"Click<\/a><\/p>\n

A text appears for a couple of seconds while the software sets up.<\/p>\n

\"Please<\/p>\n

A new app box will appear.\u00a0 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

\"Product<\/a><\/p>\n

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

\"License<\/a><\/p>\n

This app will do a scan for \u201cSetup Global Rules\u201d.\u00a0 If this scan succeeds, then it will automatically proceed to the next screen with out any user interaction.<\/p>\n

\"Global<\/a><\/p>\n

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

\"Select<\/a><\/p>\n

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

\"Ready<\/a><\/p>\n

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

\"Complete\"<\/a><\/p>\n

Verify that SQL Server has upgraded by running the \u201cSELECT @@VERSION\u201d in a SSMS query window.<\/p>\n

\"Enterprise<\/a><\/p>\n

 <\/p>\n

Final Note: To the best of my knowledge, no reboot is required after the upgrade is finished. \u00a0 This was on a Server 2012 R2 operating system.\u00a0 I was able to immediately create databases & manipulate data.<\/p>\n","protected":false},"excerpt":{"rendered":"

This blog is about upgrading SQL Server 2014 Standard Edition to the Enterprise Edition.\u00a0 This blog looks & sound much like my October 2013 post, “Upgrade SQL Server 2012 Standard … Continue Reading →<\/a><\/p>\n","protected":false},"author":1,"featured_media":1041,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[64],"class_list":["post-1029","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sql-server","tag-sql-server"],"_links":{"self":[{"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts\/1029"}],"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=1029"}],"version-history":[{"count":5,"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts\/1029\/revisions"}],"predecessor-version":[{"id":1045,"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts\/1029\/revisions\/1045"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/media\/1041"}],"wp:attachment":[{"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1029"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1029"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1029"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}