Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 471
  • Last Modified:

SQL Server Licence

Hi Team ,

Can any one tell me how to retrieve License key of SQL server.

The tools i have are showing all other software's but not SQL server License.

Thanks in Advance
Pradeep
0
Babcy
Asked:
Babcy
1 Solution
 
Brad HoweCommented:
Hi There,

Here is a simple powershell V2 script that you can use from the server to get your product Key for an installed version of SQL 2005/2008/2008R2/2012. If there server is 2003, you will need to install powershell v2.

Windows Management Framework (Windows PowerShell 2.0, WinRM 2.0, and BITS 4.0)
http://support.microsoft.com/kb/968929


http://mspowershell.blogspot.com/search?q=sql+server+key

Usage:
1. Open notepad
2. Save script to GetSQLkey.ps1
3. Open Powershell V2
4. Set-executionPolicy remotesigned (If not already set) or you'll get an error.
5. import-module -Name <drive>:\GetSQLkey.ps1
6. Get-SQLServerKey

*you may need to modify the registry locationkey value for 2005 as it may be incorrect. My 2005 version DigitalProductID Key was DigitalProductID77654 and not DigitalProductId77591.

I just used this on 3 of my instances (2005, 2008, 2008 R2) without issue and confirmed the keys are correct since i have them.

Cheers,
Hades666
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now