Re: Changing SQL startup account

From: Luke (lmihalko_at_hotmail.com)
Date: 02/25/05 

Date: Fri, 25 Feb 2005 14:03:49 -0500

Ok,
    I think I'm on the right track here, It looks like the registry
permissions are the ones at fault. Regmon proves useful again. I can go
and set the permissions manually on the following keys:
HKLM\SOFTWARE\Microsoft\MSSQLSERVER\MSSQLServer\CurrentVersion
HKLM\SOFTWARE\Microsoft\MSSQLSERVER\\Setup

This I have done previously and SEM does this too.

Of course I can set the permissions, but.... they disappear after I restart
the sql service. That is the only access denied message in regmon. The
ntfs permissions are still correct, just the registry. Has anyone run into
this before? I never came across permissions in the registry being modified
by any application that was not being setup.

And now I have, setting the permissions on the registry keys while the
cluster service was controlling the service did not properly replicate over
to the corresponding cluster server. Thus the permissions being reverted
after setting them while the service was in a "offline" state...created a
difference which was overridden by the cluster service's replication.

Why did this happen? I'm sure anyone in the group can tell me why this
occurred. And I'm gonna leave this out.

"Kevin McDonnell [MSFT]" <kevmc@online.microsoft.com> wrote in message
news:0DSXEPtGFHA.2412@TK2MSFTNGXA02.phx.gbl...
> Check the NT Application Event logs for errors while SQL is starting.
> May be problems with the account you're using to start the service with or
> if you've changed /moved database files
> to another drive location etc.
>
> Also, check the sqlstp.log for errors as well during initial setup.
>
> Thanks,
>
> Kevin McDonnell
> Microsoft Corporation
>
> This posting is provided AS IS with no warranties, and confers no rights.
>
>
>

Relevant Pages

  • 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: 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)
  • 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)
  • [NT] Exchange 2000 System Attendant Incorrectly Sets Remote Registry Permissions
    ... The following security advisory is sent to the securiteam mailing list, and can be found at the SecuriTeam web site: http://www.securiteam.com ... Microsoft Management Console snap in, the System Attendant makes ... changes to the permissions on the Windows Registry to allow Exchange ... There is a flaw in how the System Attendant makes these Registry ...
    (Securiteam)