SQLHow to Find SQL Server Product Key May 4, 201685080 views0Share By IG ShareWhen you install SQL Server, you would be prompted to enter a product key in order to install the correct Edition of SQL Server (2016, Enterprise, Standard etc.). You will not find the product key either on MSDN or on the Microsoft Volume Licensing site. In most cases, the product key is instead embedded in the MSI (Microsoft Installer) setup program. If you want to move from an Evaluation Edition to a full blown SQL Server, then you need to extract the product key from your purchased version of SQL Server. In this post, I am going to talk about exactly how to find SQL Server Product key under different scenarios.Note: If you buy something from our links, we might earn a commission. See our disclosure statement.Table of Contents ToggleHow to Find SQL Server Product KeyScenario 1: Upgrading from SQL Server Evaluation Edition to a Paid InstallationScenario: 2 When SQL Server is already installedFind official SQL Server Documentation:Download E-Book:How to Find SQL Server Product KeyScenario 1: Upgrading from SQL Server Evaluation Edition to a Paid InstallationWhen you are trying to upgrade an existing SQL Server Evaluation Edition to an Enterprise or Standard Edition using the in-place upgrade method, you would ideally need to use the “Edition Upgrade” option from the SQL Server Maintenance Menu.Ideally, the “Product Key” page populates with the correct product key. However, in a lot of cases, you would see the “Product Key” section is blank and that is where you need to find out exactly how and where to retrieve the product key. The solution to this is pretty simple. Follow the steps below:Exit the Edition Upgrade Setup completely.Run a regular Setup using the new media (Paid Version Downloaded from Microsoft Download Center or Volume Licensing website).Proceed with the “Setup Support Rules” and “Installation Type“. Once you are on the “Product Key” page, copy the product key on a notepad or somewhere secure for later usage.In some cases, you might see a blank product key using this method also. In that case, Perform the same steps on a different PC or on a Virtual Machine.Scenario: 2 When SQL Server is already installedIn this method, you can use Power Shell to check the Product keys on both local and remote SQL Server. Go to this location and download the Power Shell script and run it on your environment to find out the product key.Find official SQL Server Documentation:https://www.microsoft.com/en-us/server-cloud/products/sql-serverDownload E-Book:http://blogs.msdn.com/microsoft_press/archive/2014/04/02/free-ebook-introducing-microsoft-sql-server-2014.aspx Affiliate Disclosure: Faceofit.com is a participant in the Amazon Services LLC Associates Program. As an Amazon Associate we earn from qualifying purchases. Share What's your reaction? Excited 0 Happy 2 In Love 0 Not Sure 0 Silly 0
Enterprise TechHow to Run Microsoft SQL Server 2016 on Google Cloud Step by StepGoogle Cloud Services recently added Microsoft SQL Server to its offerings. Google’s move is primarily ...
SQLHow to Shrink SQL Server Database Log in Availability Groups using TSQLIn my previous posts, I have already spoken about the best practices of Shrinking Log ...
Enterprise TechHow to Manage your SQL Server Log and Database File Size GrowthHow to Manage your SQL Server Log and Database File Size Growth Managing the Database ...
SQLHow to Upgrade from Expired SQL Evaluation EditionHow to Upgrade from Expired SQL Evaluation Edition SQL Server Evaluation Edition is a full-blown ...