SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 LICENSE KEY
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

seethem
Starting Member

Trinidad and Tobago
46 Posts

Posted - 10/09/2007 :  09:03:44  Show Profile  Reply with Quote
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

USA
37157 Posts

Posted - 10/09/2007 :  12:17:58  Show Profile  Visit tkizer's Homepage  Reply with Quote
How is this a challenge?

Why does it matter which license key is in use on which system?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

seethem
Starting Member

Trinidad and Tobago
46 Posts

Posted - 10/09/2007 :  14:08:32  Show Profile  Reply with Quote
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.
Go to Top of Page

seethem
Starting Member

Trinidad and Tobago
46 Posts

Posted - 10/09/2007 :  14:09:24  Show Profile  Reply with Quote
It is a challenge because the alternative is to backup and re-install everything.
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37157 Posts

Posted - 10/09/2007 :  14:19:40  Show Profile  Visit tkizer's Homepage  Reply with Quote
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Setup

Your path may be different.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

jezemine
Flowing Fount of Yak Knowledge

USA
2886 Posts

Posted - 10/09/2007 :  15:14:52  Show Profile  Visit jezemine's Homepage  Reply with Quote
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
Go to Top of Page

Kristen
Test

United Kingdom
22415 Posts

Posted - 10/09/2007 :  15:48:58  Show Profile  Reply with Quote
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
Go to Top of Page

Zoroaster
Aged Yak Warrior

USA
702 Posts

Posted - 10/09/2007 :  16:57:02  Show Profile  Reply with Quote
quote:
Originally posted by seethem
I am not sure what she was thinking.



Perhaps she was smoking "crack" when she came up with the idea?



Future guru in the making.
Go to Top of Page

seethem
Starting Member

Trinidad and Tobago
46 Posts

Posted - 10/09/2007 :  18:15:54  Show Profile  Reply with Quote
Well, I told her that I am not going to jail for her... I will plead ignorance.

Thanks Tara;... I will try that...
Go to Top of Page

seethem
Starting Member

Trinidad and Tobago
46 Posts

Posted - 10/09/2007 :  18:32:13  Show Profile  Reply with Quote
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....
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37157 Posts

Posted - 10/09/2007 :  19:07:20  Show Profile  Visit tkizer's Homepage  Reply with Quote
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 Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

seethem
Starting Member

Trinidad and Tobago
46 Posts

Posted - 10/09/2007 :  19:21:40  Show Profile  Reply with Quote
Brilliant... I will try it and get back to you guys...
Go to Top of Page

seethem
Starting Member

Trinidad and Tobago
46 Posts

Posted - 10/13/2007 :  12:50:46  Show Profile  Reply with Quote
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.
Go to Top of Page

Kristen
Test

United Kingdom
22415 Posts

Posted - 10/13/2007 :  13:33:24  Show Profile  Reply with Quote
"There must be some sort of hexadecimal converter... does anyone have one..."

Windows calculator
Go to Top of Page

seethem
Starting Member

Trinidad and Tobago
46 Posts

Posted - 10/15/2007 :  07:40:42  Show Profile  Reply with Quote
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?
Go to Top of Page

jezemine
Flowing Fount of Yak Knowledge

USA
2886 Posts

Posted - 10/15/2007 :  08:28:27  Show Profile  Visit jezemine's Homepage  Reply with Quote
wipe the machine and reinstall.



elsasoft.org
Go to Top of Page

Kristen
Test

United Kingdom
22415 Posts

Posted - 10/15/2007 :  08:39:57  Show Profile  Reply with Quote
"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
Go to Top of Page

seethem
Starting Member

Trinidad and Tobago
46 Posts

Posted - 10/15/2007 :  17:03:49  Show Profile  Reply with Quote
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.
Go to Top of Page

Kristen
Test

United Kingdom
22415 Posts

Posted - 10/15/2007 :  22:39:34  Show Profile  Reply with Quote
"... 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!
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37157 Posts

Posted - 10/16/2007 :  01:39:52  Show Profile  Visit tkizer's Homepage  Reply with Quote
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 Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

seethem
Starting Member

Trinidad and Tobago
46 Posts

Posted - 10/18/2007 :  11:11:12  Show Profile  Reply with Quote
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.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000