Solved

SQL Server Licence

Posted on 2013-01-10
1
434 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
Comment Utility
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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Join & Write a Comment

Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

763 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now