Link to home
Start Free TrialLog in
Avatar of J C
J CFlag for United States of America

asked on

Need to change MSSQL service accounts to run as a different user

OS is Win2k3.

I added the user to the list in the "Allowed to logon as service" Policy on the server in question but when I changed the credentials and restarted the services it threw me an error saying access denied.
ASKER CERTIFIED SOLUTION
Avatar of zombieooo
zombieooo

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of J C

ASKER

I did what you suggested and gave the appropriate permissions on the ms sql installation directory and also to the related registry keys. I used procmon when trying to bring the services up under the new service account and it never reported any type of errors or "access denied". It just times out, windows reports that the a response was not received with the expected amount of time.
Avatar of J C

ASKER

The only thing that worked after making the changes you and other articles I've found suggested was to make the service account a local administrator account.