Troubleshooting the SQLExecutiveCmdExec Account

Under certain circumstances, the SQLExecutiveCmdExec account can prevent a task from starting. These circumstances include:

• An improper installation of the SQLExecutiveCmdExec account.
• The removal of the SQLExecutiveCmdExec account.
• An SQLExecutiveCmdExec account password that was changed outside of the Configure SQL Executive dialog box.

A message for a failed task will appear in the Task History dialog box.

The following section explains the messages you can receive, the cause, and the solution.

Message

"A required privilege is not held by the client."

Cause

The SQL Executive service account does not have the privileges that are required to initiate a logon as the SQLExecutiveCmdExec account.

Solution

Open the Configure SQL Executive dialog box and reset the Service Startup Account to a different account, for example, the System Account, and then set it back to the desired user account.

You can manually assign the privileges to the startup account by using the Windows NT User Manager application. The privileges are: Act as Part of the Operating System, Replace a System Level Token, and Increase Quotas. If the SQL Executive service startup account is the current session's account, you must log off and then back on after setting these privileges. You also must stop and restart the SQL Executive server.

Message

"A problem occurred while attempting to log on as the Windows NT user 'SQLExecutiveCmdExec': [specific logon problem description]." An example of [specific logon problem description] is "Logon failure: unknown user name or bad password."

Cause

The SQLExecutiveCmdExec account does not exist, or it exists but is not defined correctly. For example, the password has been changed or the account has been disabled.

Solution

Open the Configure SQL Executive dialog box and choose the Reset CmdExec Account button.

    To view the task history log

1. From the Server Manager window, select a server.
2. Under the selected server, double-click the SQL Executive icon.

   The Manage Scheduled Tasks window appears.

3. From the task list, select the task to view history for.
4. From the Manage Scheduled Tasks toolbar, choose the Task History button.

   The Task History dialog box appears.