Re: SQL 2K Install - Local User for Services does not work...

My services do not run under the Local System account. As an example,
let's say my machine name is MACHINENAME and my local, non-admin
account is named NONADMIN.

During the installation of SQL2K, if you choose the Custom Install
option, you are prompted for the Service Account information. You can
choose either "Local System Account" or specify a "Domain Account". I
chose the Domain Account and entered NONADMIN as the user name, entered
the password, and entered MACHINENAME as the domain name. According to
what I've read, the installation should have set the appropriate
permissions on any directories and registry keys as necessary. After
the installation completed, I was unable to get the SQL Services to
start up.

However, if I added MACHINENAME\NONADMIN to the BUILTIN\Administrators
group on the machine, the services would start right up. That is how I
figured out that it must be a permissions problem. So, I removed
MACHINENAME\NONADMIN from the BUILTIN\Administrators group, and I went
through all of the directories and registry keys to make sure the
correct permissions were set (I may not have a good list, because each
site seems to mention different directories and keys). Still, I was
unable to start the services.

I tried this on another machine as well, but I used an actual Domain
account and had the same results.

Hope this helps explain it better.

Jeremy

.

Relevant Pages

  • To Mike Brannigan
    ... addtional admin account with a totally different name, ... the security settings to take ownership, and the folder was still locked. ... >> that those files still belong to me from the last installation of WinXP? ...
    (microsoft.public.windowsxp.security_admin)
  • Re: Advanced Client install nightmare
    ... I have previously successfully installed a client over the network, ... I can succesfully connect to the remote registry using the account. ... MVP Windows Server System - SMS ... account specified in the Client push installation properties. ...
    (microsoft.public.sms.admin)
  • Re: XP Wont Log-In; returns Me to Welcome Screen
    ... but doesn't correct the registry damage. ... This is particularly useful if you have an OEM installation ... Expert Zone - www.microsoft.com/windowsxp/expertzone Unofficial FAQ for Windows Server 2003 at ... Only now it shows teh desktop, or> rather just the wallpaper, for a split second and then goes to the welcome> screen and shows my account on there like it would if you have numerous> accounts or an account with a password. ...
    (microsoft.public.windowsxp.basics)
  • Re: Advanced client install!
    ... Your Push installation account must be a member of ... Now have brought up a new installation and things are working fine ... > ccm.log from the site server giving information of the status of the ... > Getting a new request from queue "Retry" after 100 millisecond delay. ...
    (microsoft.public.sms.admin)
  • Re: can other users use program?
    ... the installation routine for this application doesn't "know" ... how to handle individual user profiles, ... Start Menu folder and Desktop folder shortcuts from the user profile ... Some Programs Do Not Work If You Log On from Limited Account ...
    (microsoft.public.windowsxp.basics)