How to change the SQL server 2000 Product Key without reinstall
-
dear all
is that possible that we change the installed SQL server 2000 product key with the new product key without reinstall it ?
if yes, any impact after change it ?
thanks in advance
regards
Jason
-
Anyone can advice me on this ? need help, urgent !
Thanks.
regards
Jason
-
Theres a product key
-
Yes but I also don't recall having to use it during the install. You just have to be able to account for the number of running instances as being licensed.
-
It might depend on the version whether or not you have to plug in a key. I have to on my 2005 Developer Edition.
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font] -
i have a valid product key. So, can anyone sharing his/her experience on changing the product key without doing SQL2000 server re-installation ?
Pls advice, Pls help. Urgent.
thank.
-
Since you have a valid product key, I'd personally just call MS and tell them why you need to do it, and see if they'll assist you. Since this could potentially affect future licensing schemes as you upgrade, I'd prefer to get the answer from the source, even if there is a hack that would work for now.
-
i do call MS support and they will only feedback to me AFTER i pay the per ticket support fees. and their rates is not cheap. and, i have not budget on it.
moreover, i was installed wrong product key into a production server and i only knew after a month. that why i need to change the key without reinstalling caused the database server can't shutdown due to some critical application is running on it. PLEASE HELP.
-
As long as you can produce a valid key if ever questioned I would make a note of the issue on the box and keep the valid key in a safe place with notes with the key in so noone assumes can be used. I wouldn't think MS would fine you for a mistake as long as you can provide valid proof of ownership (which outweighs the key itself). If you know the key you typed you might try searching the registry but anything you do there is your own choice and I do not condone changing the registry especially on a critical system.
But of course I am not a representative of MS so take everything I have said with a grain of salt.
Additionally call your MS sales agent and tell them your issue and they might be able to better help you.
-
i still un-safe even i have hardcopy certificate of it cause MS still fine me saying that i m using product key belonging to others. and, my MS sales agent hasve feedback to me- pls reinstall.
That why i wanna find out is there a way to change the sql product key without reinstalling.
Pls advice.
-
There is a product called Belarc Advisor http://www.belarc.com/free_download.html that can read the product ID's and keys from a regular PC, so that implies that those keys are stored somewhere, hopefully in the Windows registry. If that's the case, try searching the registry for your "wrong" product key, maybe you can find & update it. Just a thought.
Did somebody from MS actually contact you & say that you used the wrong key?
I used to work with a Fortune 500 company that was audited by MS, they had about 9,000 PC's with Windows, Office, Backoffice etc. and they only had to present documentation that showed that they purchased the required number of licenses. Nobody ever went from PC to PC spot-checking anything.
-
for large organization , their MS license is different with those small company. The large corp is purchase tier-1 enterprise license-open license. If there is 10-20 machine company , their will audit it. I was using belarc to audit my sql server then i find out i was install using wrong product key ( the product key was belong to our client ) and i can't re-install it due to critical mission system running on it. that why i looking advice/help any trick to change the product key without re-install ! Thanks.
-
I logged in to the MS Managed Newsgroups, didn't find a direct answer to your question but the key is stored in the registry here:
HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\80\Registration
Name: CD_KEY
Type: REG_SZ
Data: (your 25-character product key should display here)
The are other registry keys named DigitalProductID and ProductID. I don't know if you can change the CD_KEY without changing those other keys, too. If you do edit the registry don't forget to back up first.
-
thanks you very much. Will setup a test machine and try it out.
-
Hi Jason, just checking to see if you found a solution.
I have some more info about those registry keys. I have SQL 2000 Dev installed on three PC's - Win 2000 SP4, Win XP Pro SP2, and Vista Business - the CD_KEY is the same, but all three have different ProductID values in the last five digits. Not sure if that is due to the different OS, but apparently the ProductID is not hard-coded on the media.
If I run SELECT @@version, they all return version 8.00.760 which indicates SP3a is installed on all of them. I used the same media for all the PC's.
The DigitalProductID is a binary value that has the ProductID embedded, plus some other bits that I'm not sure about.
Not sure if that helps.
Viewing 15 posts - 1 through 15 (of 15 total)
You must be logged in to reply to this topic. Login to reply