Author |
Topic |
seethem
Starting Member
46 Posts |
Posted - 2007-10-09 : 09:03:44
|
New challenge!!!!I have already installed a SQL Server 2005 cluster with several instances and I want to change the license key to another one.How can I do this with out having to re-install?seethem. |
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-10-09 : 12:17:58
|
How is this a challenge?Why does it matter which license key is in use on which system?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
seethem
Starting Member
46 Posts |
Posted - 2007-10-09 : 14:08:32
|
Hi Tara,Because the Junior DBA installed a version that is a CRACK software and not one of the corporate license.I am not sure what she was thinking. |
|
|
seethem
Starting Member
46 Posts |
Posted - 2007-10-09 : 14:09:24
|
It is a challenge because the alternative is to backup and re-install everything. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-10-09 : 14:19:40
|
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\SetupYour path may be different.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-10-09 : 15:14:52
|
if your junior "dba" installed a crack, my preference would be to wipe the disk and start all over. who knows what's on there now. do you really trust the binaries that came with the cracked version? elsasoft.org |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-09 : 15:48:58
|
Bizarre! We've had the juniors lift an Enterprise Install CD off the shelf and install on a laptop (for example) ... Ho!Hum! ... but never had a Junior download a Crack in order to make an install.Kristen |
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-10-09 : 16:57:02
|
quote: Originally posted by seethemI am not sure what she was thinking.
Perhaps she was smoking "crack" when she came up with the idea? Future guru in the making. |
|
|
seethem
Starting Member
46 Posts |
Posted - 2007-10-09 : 18:15:54
|
Well, I told her that I am not going to jail for her... I will plead ignorance.Thanks Tara;... I will try that... |
|
|
seethem
Starting Member
46 Posts |
Posted - 2007-10-09 : 18:32:13
|
Hi Tara,Found it.Granted this is the first time I have ever seen the PRODUCT_CODE. Is there anything I need to do before I change it?* Shut down the instances?* Bearing in mind this is a cluster... should I stop one of the nodes at a time?Will this work? is it all that must be done?Thank you for bearing with my ignorance.... |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-10-09 : 19:07:20
|
I have no idea if it will work or not. The code doesn't matter though as it isn't tracked information. If MS ever does an audit on your system, you would need to prove licenses were purchased for each server. We've done a couple of audits before.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
seethem
Starting Member
46 Posts |
Posted - 2007-10-09 : 19:21:40
|
Brilliant... I will try it and get back to you guys... |
|
|
seethem
Starting Member
46 Posts |
Posted - 2007-10-13 : 12:50:46
|
Ok ... I am fresh out of ideas. I don't think it is going to be as easy as I thought. There must be some sort of hexadecimal converter... does anyone have one... This is a cluster and the instances have a different number lol... just my luck. |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-13 : 13:33:24
|
"There must be some sort of hexadecimal converter... does anyone have one..."Windows calculator |
|
|
seethem
Starting Member
46 Posts |
Posted - 2007-10-15 : 07:40:42
|
quote: Originally posted by Kristen "There must be some sort of hexadecimal converter... does anyone have one..."Windows calculator
No I mean, that the new CD key can't simply be key-ed into the PRODUCTCODE field in the registry.Unfortunately... because the CD key has letter like "W" and so forth... But the product key looks like it is in hexadecimal... Anyone with any ideas? |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-10-15 : 08:28:27
|
wipe the machine and reinstall. elsasoft.org |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-15 : 08:39:57
|
"I mean, that the new CD key can't simply be key-ed into the PRODUCTCODE field in the registry"Sorry, I clearly didn't read that very well, I though you were after some program to do a Hex Calculation. Apologies.I agree with jezemine. Unless you are sure you know what the Crack changed and can reverse its actions. Even then I'm not sure I'd be able to sleep at night ... Kristen |
|
|
seethem
Starting Member
46 Posts |
Posted - 2007-10-15 : 17:03:49
|
Fortunately we were able to determine that she used an Enterprise Edn. for the base install from her previous company. Interesting isn't it.The other guys on the team built the rest of the instances in the cluster using the correct enterprise CD.Well better than a crack. I would hate to have them perform a complete re-install. But it seems that this may be the only option. |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-15 : 22:39:34
|
"... from her previous company. Interesting isn't it."She couldn't upload your CDs and License numbers on the internet for me to use, could she? Are they going to lock her up? We need more stories like this on SQL Team ... its better than watching TV! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-10-16 : 01:39:52
|
Personally I'd just leave it as it is and contact my MS rep to find out if we were okay with how it was. I doubt MS cares as long as you are licensed properly. In fact, I know they don't care since we've been through audits before. I use the same license key for each of my installations.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
seethem
Starting Member
46 Posts |
Posted - 2007-10-18 : 11:11:12
|
Tara, exactly the advice from the local MS office. We paid, the numbers marry back, so they are happy.Kristen, no she is not going to jail. At least not yet. |
|
|
Next Page
|