This may seem like a stupid question but i have a server licensed per processor (4 processors) but would like to have it licensed per user. The licensing setup in control panel only shows options for per processor or per devide. How do i get to license per user without reinstalling?
Once a licensing mode is set(be it per seat or per processor) you cannot change modes. With the SQL Server 2000 Licensing setup utility in control panel its only possible to add device or processor licenses after installing SQL Server.
But there is a workaround via a registry hack.
You have to edit the registry - Regedt32, Hkey_Local_Machine, Software, Microsoft, Microsoft SQL Server, 80, MSSQLLicenseInfo, MSSQL8.00, Mode key. Change it to 0 and you get both options available again.
If i use the registry hack then i only have the options of per processor licensing or per device licensing. Can i change to per user licensing without reinstalling. In the control panel utility, there is no option for per user.