Error 21002

[Radha]

Hello,

On SQL Server 6.5, I've logged in as sa and tried to edit Security Option from Standard to Mixed and I'm getting error 21002 [SQL Server] RegCreateKeyEx # 5 Access Denied. I tried to edit any configuration and it gave me same error. I don't know whats the problem.

Any Help is Appreciated

Thanks

radha

[lodie]

I solved it once I missed security rigths, check the following:

- Opened Registry Editor
- Highlighted HKey_Local_MachineSoftwareMicrosoftMSSQLServer
- Clicked the "Security" menu and selected "Permissions"
- Found that the domain account that was used to start MSSQLServer and
SQLExecutive didn't have any permissions on this key.
- Added the MSSQLServer startup account.
Gave it "full control"
- Clicked "Replace Permissions on Existing SubKeys"
- This fixed all error messages.


------------
Radha at 12/31/2001 12:50:29 PM

Hello,

On SQL Server 6.5, I've logged in as sa and tried to edit Security Option from Standard to Mixed and I'm getting error 21002 [SQL Server] RegCreateKeyEx # 5 Access Denied. I tried to edit any configuration and it gave me same error. I don't know whats the problem.

Any Help is Appreciated

Thanks

radha