Help changing SQL startup account - registry permissions problem?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bill - 07 Mar 2006 19:39 GMT

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.

Reply to this Message

Jasper Smith - 07 Mar 2006 23:31 GMT

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.

Signature

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

>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,
[quoted text clipped - 7 lines]
>
> Thanks for any help.

Reply to this Message

clementsm@gmail.com - 28 Mar 2006 23:29 GMT

You need to make sure the the account you are using to run SQL server
(and the account you are using to run SQL Agent) both have full control
over the following registry key:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\SQLServerSCP

Take care

Max

> 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,
[quoted text clipped - 7 lines]
>
> Thanks for any help.

Reply to this Message