We are trying to configure registry settings to allow sql server service to run on a service account in SQL Server 2005. The registry has changed quite a bit from SQL 2000, and we are missing a setting in the software keys that causes sql server service not to start. If we apply permissions to all of HKEY_LOCAL_MACHINE/SOFTWARE, then the service starts, however company security policies do not allow this. Are there any specific keys we should look at, other than the obvious Microsoft/Microsoft SQL Server and Microsoft/MSSQL keys, in which we have already granted permissions to the service account?
Thanks,
Dave
Manually changing the service account is not a supported operation. Changing the service account should only be done via the SQL Server Configuration Manager tool. For further questions about this tool, you can use the SQL Server Tools General forum.
Thanks
Laurentiu
No comments:
Post a Comment