Finding SQL Product key in sql 2008 r2

Question

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: 734418 More actions · Answer 1

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

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: 734418 More actions · Answer 3

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

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