{"id":48102,"date":"2021-03-22T09:00:54","date_gmt":"2021-03-22T08:00:54","guid":{"rendered":"https:\/\/nolabnoparty.com\/?p=48102"},"modified":"2021-03-20T16:22:21","modified_gmt":"2021-03-20T15:22:21","slug":"enable-sql-server-when-evaluation-period-has-expired","status":"publish","type":"post","link":"https:\/\/nolabnoparty.com\/en\/enable-sql-server-when-evaluation-period-has-expired\/","title":{"rendered":"Enable SQL Server when the evaluation period has expired"},"content":{"rendered":"<p><img decoding=\"async\" class=\"aligncenter wp-image-48113 size-full\" title=\"enable-sql-server-when-evaluation-period-has expired-01\" src=\"https:\/\/nolabnoparty.com\/wp-content\/uploads\/2021\/03\/enable-sql-server-when-evaluation-period-has-expired-01.jpg\" alt=\"enable-sql-server-when-evaluation-period-has expired-01\" width=\"602\" height=\"202\" \/><\/p>\n<p>The SQL Server evaluation edition is <strong>free for 180 days<\/strong> but when the evaluation period has expired, the SQL Server <strong>shutdown and remains offline<\/strong>.<\/p>\n<p>To resume the SQL Server functionality, you need a <strong>valid license<\/strong> and perform the <strong>upgrade procedure<\/strong>.<!--more--><\/p>\n<p>&nbsp;<\/p>\n<h2>Check if the evaluation period has expired<\/h2>\n<p>If the SQL service doesn't start, check the logs in the <strong>Event Viewer<\/strong> to see if the evaluation period has expired. The error message reported is self-explanatory. When the evaluation period has expired, the <a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/sql-server-2019\" target=\"_blank\" rel=\"noopener noreferrer\">SQL Server<\/a> will no longer work.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter wp-image-48115 size-large\" title=\"enable-sql-server-when-evaluation-period-has expired-02\" src=\"https:\/\/nolabnoparty.com\/wp-content\/uploads\/2021\/03\/enable-sql-server-when-evaluation-period-has-expired-02-600x348.jpg\" alt=\"enable-sql-server-when-evaluation-period-has expired-02\" width=\"600\" height=\"348\" \/><\/p>\n<p>&nbsp;<\/p>\n<h2>Enable the SQL Server<\/h2>\n<p>To restore the server functionality, you need first to download the SQL Server installation .ISO file then run the <strong>installation\u00a0wizard<\/strong>.<\/p>\n<p>From the installation wizard, access the <strong>Maintenance<\/strong> area and click <strong>Edition Upgrade<\/strong> option link.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter wp-image-48117 size-large\" title=\"enable-sql-server-when-evaluation-period-has expired-03\" src=\"https:\/\/nolabnoparty.com\/wp-content\/uploads\/2021\/03\/enable-sql-server-when-evaluation-period-has-expired-03-600x453.jpg\" alt=\"enable-sql-server-when-evaluation-period-has expired-03\" width=\"600\" height=\"453\" \/><\/p>\n<p>Select <strong>Enter the product key<\/strong> and insert the purchased license. Click <strong>Next<\/strong>.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter wp-image-48119 size-large\" title=\"enable-sql-server-when-evaluation-period-has expired-04\" src=\"https:\/\/nolabnoparty.com\/wp-content\/uploads\/2021\/03\/enable-sql-server-when-evaluation-period-has-expired-04-600x453.jpg\" alt=\"enable-sql-server-when-evaluation-period-has expired-04\" width=\"600\" height=\"453\" \/><\/p>\n<p>Accept the EULA and click\u00a0<strong>Next<\/strong>.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter wp-image-48121 size-large\" title=\"enable-sql-server-when-evaluation-period-has expired-05\" src=\"https:\/\/nolabnoparty.com\/wp-content\/uploads\/2021\/03\/enable-sql-server-when-evaluation-period-has-expired-05-600x453.jpg\" alt=\"enable-sql-server-when-evaluation-period-has expired-05\" width=\"600\" height=\"453\" \/><\/p>\n<p>Click <strong>Next<\/strong>.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter wp-image-48123 size-large\" title=\"enable-sql-server-when-evaluation-period-has expired-06\" src=\"https:\/\/nolabnoparty.com\/wp-content\/uploads\/2021\/03\/enable-sql-server-when-evaluation-period-has-expired-06-600x453.jpg\" alt=\"enable-sql-server-when-evaluation-period-has expired-06\" width=\"600\" height=\"453\" \/><\/p>\n<p>Click <strong>Upgrade<\/strong>.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter wp-image-48125 size-large\" title=\"enable-sql-server-when-evaluation-period-has expired-07\" src=\"https:\/\/nolabnoparty.com\/wp-content\/uploads\/2021\/03\/enable-sql-server-when-evaluation-period-has-expired-07-600x453.jpg\" alt=\"enable-sql-server-when-evaluation-period-has expired-07\" width=\"600\" height=\"453\" \/><\/p>\n<p>After few minutes, the Edition Upgrade procedure completes successfully. Click <strong>Close<\/strong> to exit the wizard.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter wp-image-48127 size-large\" title=\"enable-sql-server-when-evaluation-period-has expired-08\" src=\"https:\/\/nolabnoparty.com\/wp-content\/uploads\/2021\/03\/enable-sql-server-when-evaluation-period-has-expired-08-600x453.jpg\" alt=\"enable-sql-server-when-evaluation-period-has expired-08\" width=\"600\" height=\"453\" \/><\/p>\n<p>From <strong>Start &gt; Run<\/strong> enter the command <em>services.msc<\/em> and click <strong>OK<\/strong>. Right click the SQL Server service name and select <strong>Start<\/strong>.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter wp-image-48129 size-large\" title=\"enable-sql-server-when-evaluation-period-has expired-09\" src=\"https:\/\/nolabnoparty.com\/wp-content\/uploads\/2021\/03\/enable-sql-server-when-evaluation-period-has-expired-09-600x346.jpg\" alt=\"enable-sql-server-when-evaluation-period-has expired-09\" width=\"600\" height=\"346\" \/><\/p>\n<p>When the service status is reported as <strong>Running<\/strong>, the SQL Server resumes its functionality.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter wp-image-48131 size-large\" title=\"enable-sql-server-when-evaluation-period-has expired-10\" src=\"https:\/\/nolabnoparty.com\/wp-content\/uploads\/2021\/03\/enable-sql-server-when-evaluation-period-has-expired-10-600x240.jpg\" alt=\"enable-sql-server-when-evaluation-period-has expired-10\" width=\"600\" height=\"240\" \/><\/p>\n<p>Now you can use the <strong>SQL Server Management Studio<\/strong> to establish <a href=\"https:\/\/nolabnoparty.com\/en\/vmware-horizon-7-view-event-database-configuration\/\">database connection<\/a> and check if everything is fine on your SQL Server.<\/p>\n<p><img decoding=\"async\" title=\"signature\" src=\"https:\/\/nolabnoparty.com\/wp-content\/uploads\/images\/firma.jpg\" alt=\"signature\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>The SQL Server evaluation edition is free for 180 days but when the evaluation period has expired, the SQL Server shutdown and remains offline. To resume the SQL Server functionality, you need a valid license and perform the upgrade procedure.<\/p>\n","protected":false},"author":3,"featured_media":48113,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"rop_custom_images_group":[],"rop_custom_messages_group":[],"rop_publish_now":"initial","rop_publish_now_accounts":{"linkedin_93tdZWzMZc_93tdZWzMZc":"","facebook_2879994398731222_17841400390232720":"","twitter_113568041_113568041":"","mastodon_115463926174894442_115463926174894442":""},"rop_publish_now_history":[],"rop_publish_now_status":"pending","footnotes":""},"categories":[1065,916],"tags":[947,1521,1572,718],"class_list":["post-48102","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-microsoft-en","category-mssql-en","tag-evaluation-en","tag-expired-en","tag-server-en","tag-sql-en","has_thumb"],"_links":{"self":[{"href":"https:\/\/nolabnoparty.com\/en\/wp-json\/wp\/v2\/posts\/48102","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nolabnoparty.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nolabnoparty.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nolabnoparty.com\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/nolabnoparty.com\/en\/wp-json\/wp\/v2\/comments?post=48102"}],"version-history":[{"count":0,"href":"https:\/\/nolabnoparty.com\/en\/wp-json\/wp\/v2\/posts\/48102\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/nolabnoparty.com\/en\/wp-json\/wp\/v2\/media\/48113"}],"wp:attachment":[{"href":"https:\/\/nolabnoparty.com\/en\/wp-json\/wp\/v2\/media?parent=48102"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nolabnoparty.com\/en\/wp-json\/wp\/v2\/categories?post=48102"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nolabnoparty.com\/en\/wp-json\/wp\/v2\/tags?post=48102"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}