Sometimes you’ll need to retrieve your SQL Server Product Key from an existing installation on your Client or Server machine: the most common scenario takes place when you have an old Server to move or relocate and no one around you seem to remember where the license are… or if you’ve simply lost the Service Key post-it.
Hello, There is no public download of the Enterprise Edition available, but you can download Evaluation Edition, you then only have to enter your Enterprise license key to get Enterprise Edition installed: Microsoft® SQL Server® 2012 Evaluation.
Luckily enough, you can easily get this information back thanks to this neat PowerShell script made by Jacob Bindslet:
- Get SQL Server Product Keys for Local and Remote Servers Using a string of servers, a text file, or Central Management Server to provide a list of servers, this script obtains the product key and versions for all installed instances on a server or cluster. Supports SQL Server 2005-2014.
- Download Cracked Microsoft SQL Server 2012 Enterprise SP1 Microsoft’s SQL Server 2012, the latest version of its SQL Server platform, is in many ways a response to the demands of the cloud and “big data” applications.
- Hi, I am running SQL Server 2008 Standard and i want to find out the product key being used for it and replace it with the different one, please suggest.
2 4 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 | ## function to retrieve the license key of a SQL 2008 Server. $hklm=2147483650 $regPath='SOFTWAREMicrosoftMicrosoft SQL Server100ToolsSetup' $regValue2='PatchLevel' Foreach($targetin$targets){ $win32os=$null $wmi=[WMIClass]'$targetrootdefault:stdRegProv' $data=$wmi.GetBinaryValue($hklm,$regPath,$regValue1) [string]$SQLver=$wmi.GetstringValue($hklm,$regPath,$regValue2).svalue [string]$SQLedition=$wmi.GetstringValue($hklm,$regPath,$regValue3).svalue $charsArray='B','C','D','F','G','H','J','K','M','P','Q','R','T','V','W','X','Y','2','3','4','6','7','8','9' For($i=24;$i-ge0;$i--){ For($j=14;$j-ge0;$j--){ $binArray[$j]=[math]::truncate($k/24) } If(($i%5-eq0)-and($i-ne0)){ } $win32os=Get-WmiObjectWin32_OperatingSystem-computer$target $objAdd-MemberNoteproperty Computer-value$target $objAdd-MemberNoteproperty OSCaption-value$win32os.Caption $objAdd-MemberNoteproperty OSArch-value$win32os.OSArchitecture $objAdd-MemberNoteproperty SQLedition-value$SQLedition $objAdd-MemberNoteproperty ProductKey-value$productkey } |
The script works with any SQL Server edition & version starting from 2005: SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2. Pay close attention, though, if you’re using Sql Server 2012 or Sql Server 2014 you’ll have to make some small modifications to that code.
For Sql Server 2012 you need to replace two lines of code. In details, replace line 5 with the following line:
$regPath='SOFTWAREMicrosoftMicrosoft SQL Server110ToolsSetup' |
And also replace line 16 with the following line (thanks to gprkns for pointing it out):
You can also take a look of the complete script code for Sql Server 2012 at the following link.
For Sql Server 2014, Microsoft moved the DigitalProductID node to the actual instance name in the registry, so you will need to replace line 5 with something similar to the following (depending on your installation):
And all of this is done to avoid potential issues. Because IObit Driver Booster Activator can do it with just one click. 
Because outdated drivers might affect your computer’s performance. Another important feature of it is its fast downloading speed. And also can spoil your fgaming performance as well.
$regPath='SOFTWAREMicrosoftMicrosoft SQL ServerMSSQL12.[YOUR SQL INSTANCE NAME]Setup' |
All you have to do in order to execute this script is to perform these actions:
- Launch a PowerShellprompt (Start > Run, then type powershell and press ENTER.
- Copy the above function text and past it directly inside the prompt area.
- Press ENTER a couple times, just to be sure you’re back to the prompt.
- Type GetSqlServerProductKey, then press ENTER.
If everything has been done like it should you’ll be able to see the following informations:
As you can see there’s a lot of stuff regarding your SQL Server installation, most of them you should know already, the latter being the Product Key.
Planner 5D Interior Design v1.6.0 5D Planner is a simple to use application that allows to create the interior design in 2D and 3D modes with ease ONLINE OR OFFLINE. You can create your dream home in minutes without any training or special practices or complicated manuals. Mar 11, 2017 Planner 5D - Interior Design APK 1.10.4 for Android. Download Planner 5D - Interior Design APK for PC. Play Planner 5D - Interior Design on pc with KOPLAYER Android Emulator. Planner 5D - Interior Design for PC free download. Download offline planner 5d full version for free. Photo & Graphics tools downloads - Planner 5D by Planner 5D, LLC. And many more programs are available for instant and free download. Planner 5d full windows 10 con serial key gratis en español. Download planner 5d full version torrent for free. Photo & Graphics tools downloads - Planner 5D by Planner 5D, LLC. And many more programs are available for instant and free download. How to Increase Internet speed in Windows 10. Or Origin, torrent downloaders like.
That’s all for now: happy recover!
my version of sql server 2008 Enterprise edition has expired and I have a new key how to change the old key without uninstall or any modification to the installed server or instances.
2 Answers
According to this article (referenced originally by nopol's answer) it is possible to change the product key of a SQL Server 2008[1] installation by performing the following steps:
- Open SQL Server Installation Centre
- From the Maintenance screen choose Edition Upgrade
- Enter the new new product key
It is also possible to change the product key at the command line using the command
Microsoft Sql Server 2012 Enterprise Edition Serial Key Code
Setup.exe /q /ACTION=editionupgrade /INSTANCENAME=<%INSTANCE_NAME% /PID=%NEW_PRODUCT_KEY> /IACCEPTSQLSERVERLICENSETERMS
Where:%INSTANCE_NAME% is the SQL Server instance that will have its product ID changed`
%NEW_PRODUCT_KEY% represents the new product key that the will be applied to the specified SQL Server Instance.
Notes:
Sql Server 2012 Enterprise Evaluation
- The linked article specifically references changing the license key for SQL Server 2008 Developer Edition. This author is unable to determine whether this process allows changing of keys between other editions due to lack of required software to test with.
- The
/IACCEPTSQLSERVERLICENSETERMSparameter indicates your acceptance of the SQL Server licensing terms. Make sure you understand the license terms that apply to your (or your organization) before using this switch.
I would recommend that you take a look at this post: