SQL Executive - Service Startup Account Error

Hello all,

I just inherited a SQL Server that was set up by a non-DBA. It`s running NT 4.0 and SQL Server 6.50 - 6.50.201 (the vendor hasn`t certified the product on SP4). I am trying to change the SQL Executive Service to use a non-system logon account. The account that I want to use is running SQL Executive on 9 other servers.

I went into Usrmgr and added the account to the administrators group. Made sure that it has rights to:
log on as a service, log on as a batch job, increase quotas, act as part of the operating system, replace a process level token.

When I try to change to that id in services, I get the following error:

"cannot set the startup parameters for SQL Executive service. Error 1057 occurred. The account name is invalid or does not exist."

Looking in Technet, I found that if "log on as a service" isn`t set you could get this message but I`ve check/re-checked, had someone else check and it`s set.

Any help would be appreciated!

Hi Joan,

Non-system logon account is a domain account (I guess so)?

Add that account to Local Administrators group at NT+SQL server (be sure to manage local computer accounts - not the domain accounts)
Go to Control Panel - Services - SQLExecutive - Startup - Log On as This Account - select that account and enter password. Stop and Restart service.

On 8/5/98 9:34:53 AM, Joan Olszewski wrote:
> Hello all,

I just inherited a SQL Server that was set up by a non-DBA.
> It`s running NT 4.0 and SQL Server 6.50 - 6.50.201 (the vendor hasn`t
> certified the product on SP4). I am trying to change the SQL Executive
> Service to use a non-system logon account. The account that I want to use
> is running SQL Executive on 9 other servers.

I went into Usrmgr and
> added the account to the administrators group. Made sure that it has
> rights to:
log on as a service, log on as a batch job, increase quotas,
> act as part of the operating system, replace a process level token.

When
> I try to change to that id in services, I get the following
> error:

"cannot set the startup parameters for SQL Executive service.
> Error 1057 occurred. The account name is invalid or does not
> exist."

Looking in Technet, I found that if "log on as a service" isn`t
> set you could get this message but I`ve check/re-checked, had someone else
> check and it`s set.

Any help would be appreciated!