Re: Help changing SQL startup account - registry permissions problem?

Any reason you didn't use Enterprise Manager for this? It takes care of
setting all the required file and registry permissions. Try using EM to set
the service account to Local System and then back to your domain user
account and see if that helps.

--
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com


"bill" <wbeatty@xxxxxxxxxxx> wrote in message
news:fklPf.19205$NS6.14560@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I changed the SQL Server startup account on my server to a domain user. I
followed KP 283811 to give the appropriate permissions to registry keys,
NTFS file permissions, and Windows User rights. Everything SEEMS to work
properly within SQL Server as far as backups, etc. but I came across
something that doesn't. If I try to the SQL Server instance to Active
Directory from within Enterprise Manager I get an error "Error 14303: Store
Procedure 'sp_ActiveDirectory_SCP' failed to access registry key. I guess
my worry is that if this sp is giving me an error, there may be others that
I'm unaware of.

Thanks for any help.



.

Relevant Pages

  • Re: Service fails to start when only tcp/ip protocol is set
    ... it will handle the necessary registry ... permissions for you - as well as the other needed rights and ... Change the SQL Server or SQL Server Agent Service ... Account Without Using SQL Enterprise Manager in SQL Server ...
    (microsoft.public.sqlserver.server)
  • Re: Active Directory domain policy not available - Windows cannot access the registry information (5
    ... shuffling the registry around as a result. ... >What share permissions did you change? ... >SYSVOL and NETLOGON shares aren't accessible. ... >the domain controller is changed but the DNS still points to the old IP ...
    (microsoft.public.backoffice.smallbiz2000)
  • Re: How do I make registry changes stick?
    ... MS-MVP Windows Shell/User ... I found that the permissions for the key were and on the ... In the Registry Editor, right click.. ... To assign permissions to a registry key ...
    (microsoft.public.windowsxp.perform_maintain)
  • Re: Interesting Behavior after update to SP3 when restoring the Ad
    ... I was also thinking setting permissions in the registry, ... Everyone to Group or users giving Full control and Read permissions to the ... to all user profiles besides just administrators. ... the address bar were back where they belong in all of the administrator ...
    (microsoft.public.windowsxp.general)
  • Re: ISA 2004 - Disk activity after SP1 or 2 installation
    ... configurations into the registry. ... permissions to the key and the sub keys: ... This newsgroup only focuses on SBS technical issues. ... you may want to contact Microsoft CSS directly. ...
    (microsoft.public.windows.server.sbs)