Hi,
I am trying to reconfigure my SQL 2000 SP3a server from Per Seat to Per
Processor licensing. Does anyone know how to do this?
Cheers,
Jamie
Hi,
Once a licensing mode is set you cannot change modes. With the SQL Server
2000 Licensing setup utility in control panel its only possible to add
device or processor licenses.
But there is an alternative by changing the registry key.
You have to edit the registry using regedt32
\\Hkey_Local_Machine\Software\XMicrosoft\Microsoft SQL
Server\80\MSSQLLicenseInfo\MSSXQL8.00\Mode key\
Change the value to 0 and you get both options available.
Thanks
Hari
SQL Server MVP
"Jamie Longmire" <jamie_longmire@.hotmail.com> wrote in message
news:eqVKmj8QFHA.3496@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I am trying to reconfigure my SQL 2000 SP3a server from Per Seat to Per
> Processor licensing. Does anyone know how to do this?
> Cheers,
> Jamie
>
|||G'day Hari,
Thanks so much for the prompt and informative response.
Interstingly, the value was already set to 0 so I changed it to 2 and the
Processor Option was enabled.
Thanks again for you your help.
Regards,
Jamie
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:%23f0HIN9QFHA.4020@.tk2msftngp13.phx.gbl...
> Hi,
>
> Once a licensing mode is set you cannot change modes. With the SQL Server
> 2000 Licensing setup utility in control panel its only possible to add
> device or processor licenses.
>
> But there is an alternative by changing the registry key.
> You have to edit the registry using regedt32
>
> \\Hkey_Local_Machine\Software\XMicrosoft\Microsoft SQL
> Server\80\MSSQLLicenseInfo\MSSXQL8.00\Mode key\
> Change the value to 0 and you get both options available.
>
> Thanks
> Hari
> SQL Server MVP
> "Jamie Longmire" <jamie_longmire@.hotmail.com> wrote in message
> news:eqVKmj8QFHA.3496@.TK2MSFTNGP12.phx.gbl...
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment