November 9, 2004 at 1:57 pm
Hi,
we have windows 2000 server with SQL Server 6.5 + SP5 installed on it. We have just installed SQL Server 2000 + SP3. Both are working fine and we are able to switch between 6.5 and 2000. But when we are trying to run upgrade wizard it is giving following error.
'Version Switch has aborted becuase
you do not have 'Full Control' permission to one of the
HKeY_LOCAL_MACHINE\Software\Microsoft\MSSQLServ* registry keys.
Please use regedt32.exe to correct this problem and try again.
We tried with system administrators login id but still giving same errors. Any help and suggestions will be appreciated.
Thank you,
November 10, 2004 at 12:53 am
Logged into Windows using an account that is part of the local windows machine Administrators group:
- Run regedt32.exe
- Browse down till you have the registry key selected
- Right click, choose Permissions
Make sure that the windows account that SQL Server is running as / the SYSTEM user / or the user that is running the upgrade wizard has Full Control ticked.
If you've followed some of the best practices and locked down your SQL Registry, or are using accounts with minimal permissions, you will need to restore your permissions after running the wizard.
A default (lax security) setup of SQL server would have left these registry settings with Full Control permissions. Obviously the wizard likes to either create/delete/edit keys, so you need to give it permissions to do so.
Julian Kuiters
juliankuiters.id.au
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply