product key

Question

Post reply

product key

roy.b

SSC Veteran

Points: 228
More actions
December 14, 2010 at 2:07 am

#232087

Hello,
Is there a way to find the product key after I installed sql2008?
We have several servers with several licenses, we want to make sure, no license has been installed twice on different servers.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Henrico Bekker One Orange Chip Points: 27652 More actions · Answer 1

USE master

GO

EXEC xp_regread 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Microsoft

SQL Server\xxx\Registration','CD_KEY'

replace xxx with you 100 or 90....

Sorry, just remembered this SP was dropped...

wont work.

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

roy.b SSC Veteran Points: 228 More actions · Answer 2

10x but it not working

RegOpenKeyEx() returned error 2, 'The system cannot find the file specified.'

Msg 22001, Level 1, State 1

(0 row(s) affected)

same ,90,100,80

harag SSC Enthusiast Points: 117 More actions · Answer 3

this might help: http://www.mssqlcity.com/Articles/Undoc/UndocExtSP.htm

xp_regread

This extended stored procedure is used to read from the registry.

Syntax:

EXECUTE xp_regread [@rootkey=]'rootkey',

[@key=]'key'

[, [@value_name=]'value_name']

[, [@value=]@value OUTPUT]

For example, to read into the variable @test-2 from the value 'TestValue' from the key 'SOFTWARE\Test' from the 'HKEY_LOCAL_MACHINE', run:

DECLARE @test-2 varchar(255)

EXEC master..xp_regread @rootkey='HKEY_LOCAL_MACHINE',

@key='SOFTWARE\Test',

@value_name='TestValue',

@value=@test OUTPUT

SELECT @test-2

Lowell SSC Guru Points: 323518 More actions · Answer 4

I have this appllicaiton in my PortableApps collection: it finds keys for 2000/2005/2008, and ifg you know where the key to anything is stored, you can add it to the config file and it will look it up for you (think SQL2008R2

Magical Jelly Bean Keyfinder v2.0.8

http://sourceforge.net/projects/keyfinder/

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 5

roy.b (12/14/2010)
Hello,
Is there a way to find the product key after I installed sql2008?
We have several servers with several licenses, we want to make sure, no license has been installed twice on different servers.

While I definitely agree with the wanting to make sure that a license was not double used, making sure one wasn't used more than once isn't really necessary.. Being true on your licensing is.

What I mean is that if you have 10 standard licenses and 10 standard servers, the fact that one of the keys may have been used twice and another not at all is not all that important.. As well as if you have 10 licenses and have 11, you know you need 1 more, regardless of which was used twice.

For cases where the number of installs is not limited (like the OS) it is more important..

Others may have different perspectives..

CEWII