Re: Change SQL Service Account

Tech-Archive recommends: Speed Up your PC by fixing your registry

There are a lot of reasons for this. One could be that the account you are using does not have permissions to start a service or your account has been locked out due to other reasons while you are logged in (I've seen this a lot of times where a generic account is used and then it gets locked out while a user is logged in using the same account). Another is not enough permissions on the account to do what it needs to do as a SQL Server service account. It is recommended to use the SQL Server tools (Management Studio or Configuration Manager) when configuring user accounts as the tools resolve the necessary ACLs needed by the account to
run as a SQL Server service account.

<kalvin.tuel@xxxxxxxxx> wrote in message news:950f4759-0402-4675-ae46-014024cd9961@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I need to change the SQL Service Account for SQL Server 2005 Express
to something that is not Admin or LocalSystem. I have followed the
steps outlined in http://support.microsoft.com/kb/283811 and in the
BOL. When I attemp to start the service using the new limited priv
account I get error 5 "Access is Denied". I think this is a Windows
permissions issue but I don't know what else to check. Just to be
sure I gave the new account Full Control on the installation drive but
still couldn't start the service. What could I be missing? Is there
a handy tool somewhere that will do this for me, in SQL 2005 Express.

Thanks.
Kalvin

.

Relevant Pages

  • Re: Execute Persmission denied on object sp_OACreate
    ... If so what access and permissions. ... The account is a windows account. ... One method to test permissions is to log in to your SQL Server box using the ... >>> SA account password and gaining access to the database. ...
    (microsoft.public.sqlserver.security)
  • Re: Specifying a logon account for SQL Server 2005 services
    ... As I mentioned using a Windows domain account with no permissions is the ... configured only for very specific server and memory configurations. ... account to use while installing SQL Server, will SQL Server give this account ...
    (microsoft.public.sqlserver.security)
  • That is permission problem
    ... SQL Server 2005 can't attach database on Windows Vista ... It seems it must be a permissions problem. ... What is the service account for SQL Server? ...
    (microsoft.public.sqlserver.tools)
  • Re: Change NT Service user name and password after installation
    ... The service has to run under a specific account that we specify to the ... There are a lot of reasons for this but would take too long to ... > permissions then this won't work. ... > the standard user names off their systems. ...
    (microsoft.public.dotnet.framework)
  • Re: simple security question (need refresher)
    ... If IIS is configured for anonymous access and you connect to SQL Server ... using Windows authentication, the IIS anonymous account ... this account or roles that this account is a member of. ... Permissions are required only on objects directly accessed by the ...
    (microsoft.public.sqlserver.security)