|
Home > Archive > microsoft.public.sqlserver.server > November 2002 > error 21002 [sql server] regcreatekeyex #5 access denied
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
error 21002 [sql server] regcreatekeyex #5 access denied
|
|
| Stephane Viau 2002-11-11, 12:23 pm |
| whats the meaning, cause and solution of this error?
the sql startup account is in administrators which has rights to those
rgistry keys.
everything worked fine, until i switched the security mode from standard to
mixed to allow replication.
sql server 65
thanks
stephane
| |
| Alvin Zhao[MS] 2002-11-11, 8:23 pm |
| Hi,
Per your post, when you switched the security mode from standard to mixed,
you got the error 21002. If this is accurate, then the following steps
should clear up your situation.
1. Start->Run->regedt32
2. Navigate to HKEY_LOCAL_MACHINE\Software\Mi
crosoft\MSSQLServer
3. Grant FullControl on this key to either to an NT group the user is a
member of
or to the user's domain account.
- Check "Replace Permissions on Existing Subkeys"
- Click "OK"
- You will receive a dialog box stating:
"Do you want to replace the permission on all existing subkeys within
MSSQLServer?"
- Click "Yes"
4. Stop and restart the MSSQLServer service for the changes to take affect.
5. Retry the operation that failed with insufficient permissions again.
6. Stop and restart MSSQLServer service for the changes to take affect.
Sincerely,
Alvin Zhao
Microsoft Support
This posting is provided "AS IS" with no warranties, and confers no rights.
|
|
|
|
|