SQL Executive Configuration Parameters

Configuration parameters for SQL Executive can be tailored and set from SQL Enterprise Manager.

    To set SQL Executive configuration parameters

  1. From SQL Enterprise Manager, in the Server Manager window select the server to set configuration parameters for.
  2. Click the right mouse button on the server's SQL Executive icon, and in the shortcut menu, choose Configure.

    The Configure SQL Executive dialog box appears.

  3. Set the following parameters.
Parameter Description
Auto-Start SQL Mail
When SQL Executive Starts		 Specifies that when SQL Executive is started it will automatically start SQL Mail. SQL Server must be running before SQL Executive is started.
Auto-Restart Server After
Unexpected Server-Down		 Specifies that if SQL Server stops unexpectedly for reasons other than a shutdown or a net stop mssqlserver command, SQL Executive will automatically restart SQL Server and then write a message to the event log.
Unexpected Server-Down
Detection Polling Interval
(minutes)		 Specifies the interval in minutes that is used by SQL Executive to check for unexpected SQL Server stoppages. The default value is 5 minutes.
Local Host Server Specifies the name of the local SQL Server. Usually this parameter is set to (default). However, if the server is set to listen on an alternate named pipe, do not use (default). Instead, select the listen-on name from the Local Host Server list. For more information about named pipes, see the Microsoft SQL Server Administrator's Companion.
Error Log File Specifies the path and the name of a file that error information for SQL Executive will be written to. An error log file adds substantial process overhead. Use the error log file only when directed to do so by Microsoft Technical Support or when you are attempting to troubleshoot a specific SQL Executive problem.
System Account Specifies that SQL Executive is assigned to run in the server's LocalSystem account.

Important: Selecting the System Account option for SQL Executive prevents the use of several features, such as replication and running scheduled tasks that involve other servers. A service running under the LocalSystem account has no user account information associated with it. This prevents certain network server software from allowing the Windows NT service to access resources.

This Account Specifies that SQL Executive will run in the security context of the Windows NT user account that is entered here. This Account will usually be a domain user account (although it can be a user account on the local server). This Account should be reserved for use by SQL Executive (users should not use it to log on). This account should be a member of the Administrators local group and have a non-expiring password.

Important: Generally, the This Account option is assigned through the SQL Server setup program when SQL Server is installed and you do not need to change it. If you must change the user account or update the password, always use the Configure SQL Executive dialog box to do so. Do not use the Services application in Control Panel, because the SQL Executive service account needs additional privileges that are only granted to the account when the Configure SQL Executive dialog box is used.
Password Specifies the password of the Windows NT user account that is assigned to SQL Executive.
Confirm Password Verifies the password of the Windows NT user account that is assigned to SQL Executive.
Reset CmdExec Account Reinstalls the SQLExecutiveCmdExec account, which is a local Windows NT account on the server that is being administered. CmdExec tasks that are owned by users other than system administrators run in the security context of this account.

This option resets the account to its default (minimum) level of access rights. Additional rights that may have been granted to this account are removed.
Reset CmdExec Password Changes the Windows NT password that is used by the SQLExecutiveCmdExec account. The new password is automatically generated by SQL Enterprise Manager.

Important: Do not use the Windows NT User Manager to change the SQLExecutiveCmdExec password. If you do, then CmdExec tasks that are owned by users other than system administrators cannot run successfully. If this problem occurs, choose the Reset CmdExec Account button.

  1. To set the specified parameters, choose OK.

For more information about using the Configure SQL Executive dialog box, see the online Help for SQL Enterprise Manager.