Microsoft SQL Server 2008 Standard serial key or number
Microsoft SQL Server 2008 Standard serial key or number
SQL Server – Retrieve Product Key from an existing installation
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.
Luckily enough, you can easily get this information back thanks to this neat PowerShell script made by Jacob Bindslet:
functionGetSqlServerProductKey{ ## function to retrieve the license key of a SQL 2008 Server. param($targets=".") $hklm=2147483650 $regPath="SOFTWARE\Microsoft\Microsoft SQL Server\100\Tools\Setup" $regValue1="DigitalProductId" $regValue2="PatchLevel" $regValue3="Edition" Foreach($targetin$targets){ $productKey=$null $win32os=$null $wmi=[WMIClass]"\\$target\root\default:stdRegProv" $data=$wmi.GetBinaryValue($hklm,$regPath,$regValue1) [string]$SQLver=$wmi.GetstringValue($hklm,$regPath,$regValue2).svalue [string]$SQLedition=$wmi.GetstringValue($hklm,$regPath,$regValue3).svalue $binArray=($data.uValue)[52..66] $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" ## decrypt base24 encoded binary data For($i=24;$i-ge0;$i--){ $k=0 For($j=14;$j-ge0;$j--){ $k=$k*256-bxor$binArray[$j] $binArray[$j]=[math]::truncate($k/24) $k=$k%24 } $productKey=$charsArray[$k]+$productKey If(($i%5-eq0)-and($i-ne0)){ $productKey="-"+$productKey } } $win32os=Get-WmiObjectWin32_OperatingSystem-computer$target $obj=New-ObjectObject $obj|Add-MemberNoteproperty Computer-value$target $obj|Add-MemberNoteproperty OSCaption-value$win32os.Caption $obj|Add-MemberNoteproperty OSArch-value$win32os.OSArchitecture $obj|Add-MemberNoteproperty SQLver-value$SQLver $obj|Add-MemberNoteproperty SQLedition-value$SQLedition $obj|Add-MemberNoteproperty ProductKey-value$productkey $obj } |
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="SOFTWARE\Microsoft\Microsoft SQL Server\110\Tools\Setup" |
And also replace line 16 with the following line (thanks to gprkns for pointing it out):
$binArray=($data.uValue)[0..16] |
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):
$regPath="SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL12.[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.
That’s all for now: happy recover!
Evaluation Product Keys for Windows Server 2008 R2
This post now forms part of our KMS and evaluation product keys series. We have shared with you all the product keys you should ever require for Microsoft user and server operating systems. You can see the full list available to you by clicking the link below:
Microsoft Evaluation and KMS Product Key Series
This is more as a reminder for ourselves when building evaluation labs for Windows Server 2008 R2 (although most people will be moving on 2012 by now) but we thought we would share this information with our visitors as well.
These product keys can be used to activate the various evaluation copies of Windows Server 2008 R2 for 180 days and have a re-arm value of 5.
You can see the list of keys that you can use below:
Evaluation Product Keys
| Operating System Version | Product Key |
| Windows Web Server 2008 R2 | KBV3Q-DJ8W7-VPB64-V88KG-82C49 |
| Windows Server 2008 R2 Standard | 4GGC4-9947F-FWFP3-78P6F-J9HDR |
| Windows Server 2008 R2 Enterprise | 7PJBC-63K3J-62TTK-XF46D-W3WMD |
| Windows Server 2008 R2 Datacenter | QX7TD-2CMJR-D7WWY-KVCYC-6D2YT |
Update – 2008 Product Keys
We have added the below keys as they include the 2008 versions and also a few alternatives for 2008 R2.
| Windows Server 2008 Standard | TM24T-X9RMF-VWXK6-X8JC9-BFGM2 |
| Windows Server 2008 Enterprise | YQGMW-MPWTJ-34KDK-48M3W-X4Q6V |
| Windows Server 2008 Datacenter | 7M67G-PC374-GR742-YH8V4-TCBY3 |
| Windows Server 2008 R2 Standard | YC6KT-GKW9T-YTKYR-T4X34-R7VHC |
| Windows Server 2008 R2 Enterprise | 489J6-VHDMP-X63PK-3K798-CPX3Y |
| Windows Server 2008 R2 Datacenter | 74YFP-3QFB3-KQT8W-PMXWJ-7M648 |
Windows Server 2012 R2
If you are looking for how to activate Windows Server 2012 R2 – then our guide here should help you through this process too:
Windows Server 2012 R2 Evaluation Activation
Windows Server 2016
We also have keys available for Server 2016 which you can view by clicking the link below:
Windows Server 2016 Evaluation Activation
Windows Server 2019
We now have added the fully up to date Product Keys for Windows Server 2019. You can take a look at our post for that using the link below:
Windows Server 2019 Evaluation Product Keys
Feedback
We would love to hear your feedback on this article so come and join us on Facebook or Twitter and let us know what you think!
SQL Server 2008 R2 product key change on production server
Question
- text/html3/1/2013 9:00:30 PMMike12700
Hello,
We have a one production server which has Microsoft SQL Server 2008 R2 (RTM) - Standard Edition (64-bit). This SQL server 2008 R2 is already activated with valid product key and is good. When this server was shipped from DELL it came up with SQL Server 2012 media but we support SQL Server 2008 R2 standard so we used one of our own license copy to activate this server. Now we traded this 2012 media with Microsoft and they have sent us back SQL Server 2008 R2 standard edition media with product key and now we want to use this new product key.
How can we change this product key on production server? Will it affect the server in case of changing the product key fails? Will the instance get corrupt?
I have one solution but I am not sure of.
By using the configuration manager, run the installation wizard, maintenance --> edition upgrade--> and there we can enter new product key.
But will this go smoothly? as we are not upgrading the edition of sql server. It has SQL Server 2008 R2 standard edition now and new one is also same one. Just product key will be different.
Your help is much appreciated.
Thank you.
Answers
- text/html3/12/2013 3:02:23 AMAlberto Morillo1
Hello,
Please call Microsoft Licensing about this issue. You can call them at 1-800-426-9400, Monday through Friday, 6:00 A.M. to 6:00 P.M. (Pacific Time) to speak directly to a Microsoft licensing specialist. You can also visit the following site for more information and support on licensing issues:
http://www.microsoft.com/licensing/mla/default.aspxHope this helps.
Regards,
Alberto Morillo
SQLCoffee.com- Marked as answer byMaggie LuoWednesday, March 13, 2013 9:59 AM
All replies
- text/html3/8/2013 9:37:21 PMMike12700
Thank you Alberto for the reply.
Can I just go ahead with the following:
Start->Microsoft SQL Server 2008 -> Configuration Tools ->SQL Server Installation Center ->Maintenance->Edition Upgrade-> and enter new product key and complete the wizard.
Will this work without any problem?
Thank you,
- text/html3/12/2013 1:47:44 AMMike12700
Hi Alberto,
I followed below way:
Start->Microsoft SQL Server 2008 -> Configuration Tools ->SQL Server Installation Center ->Maintenance->Edition Upgrade-> and enter new product key and complete the wizard.
But it gives following error:
The SQL Server product key is not valid. To proceed, re-enter the product key values from the Certificate of Authority(COA) or SQL Server pakaging.
I am sure this key is not used anywhere.
Please help with this.
Thank you,
- text/html3/12/2013 3:02:23 AMAlberto Morillo1
Hello,
Please call Microsoft Licensing about this issue. You can call them at 1-800-426-9400, Monday through Friday, 6:00 A.M. to 6:00 P.M. (Pacific Time) to speak directly to a Microsoft licensing specialist. You can also visit the following site for more information and support on licensing issues:
http://www.microsoft.com/licensing/mla/default.aspxHope this helps.
Regards,
Alberto Morillo
SQLCoffee.com- Marked as answer byMaggie LuoWednesday, March 13, 2013 9:59 AM
What’s New in the Microsoft SQL Server 2008 Standard serial key or number?
Screen Shot
System Requirements for Microsoft SQL Server 2008 Standard serial key or number
- First, download the Microsoft SQL Server 2008 Standard serial key or number
-
You can download its setup from given links:
Microsoft SQL Server 2008 Standard serial key or number & Apps for Laptop & PC Free Download
Microsoft SQL Server 2008 Standard serial key or number& Apps for Laptop & PC Free Download
Microsoft SQL Server 2008 Standard serial key or number
About Author
