-
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!
-
SQL Executive - Service Startup Account Error (reply)
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!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|