Solved

SQL Server Licence

Posted on 2013-01-10
1
441 Views
Last Modified: 2013-01-30
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
Comment
Question by:Babcy
1 Comment
 
LVL 30

Accepted Solution

by:
Brad Howe earned 500 total points
ID: 38766714
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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Sql Server group by 10 30
SQL View nearest date 5 37
T-SQL:  Collapsing 9 25
access query to sql server 3 22
Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question