Finding SQL Product key in sql 2008 r2

Question

Post reply

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

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

Steve Jones - SSC Editor SSC Guru Points: 728159 More actions · Answer 1

SSC Guru

Points: 728159

July 4, 2012 at 9:19 am

USE master



GO

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

SQL Server\80\Registration','CD_KEY'

Bipsy SSCrazy Points: 2207 More actions · Answer 2

SSCrazy

Points: 2207

July 4, 2012 at 9:22 am

I tried this but its not working and my sql server is 2008 R2 so i will be looking in 100 but i m nt able to find registeration item there.

Steve Jones - SSC Editor SSC Guru Points: 728159 More actions · Answer 3

SSC Guru

Points: 728159

July 5, 2012 at 12:26 pm

Try the key for the instance and the setup. I think I see mine in there. It's MSDN, so hard to tell if that's the right key

Ali Tailor Hall of Fame Points: 3769 More actions · Answer 4

Hall of Fame

Points: 3769

May 29, 2014 at 11:18 pm

Try this for SQl Sever 2008 R2 Enterprise

exec xp_regread 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Microsoft SQL Server\100\Tools\Setup\Client_Components_Full','ProductCode'

Ali
MCTS SQL Server2k8