Microsoft KB Archive/171291
Article ID: 171291
Article Last Modified on 10/16/2003
- Microsoft SQL Server 6.5 Standard Edition
This article was previously published under Q171291
If you run CmdExec tasks while not logged on as the system administrator (SA), you may receive the error message below. This error is reported in the task history, as well as in the Application Log of Windows NT Server's Event Viewer:
If you run xp_cmdshell while not logged on as the SA, you may receive the following error message:
The SQL Executive service (for CmdExec tasks) or the MSSQLServer service (for xp_cmdshell tasks) is not running under an account with the permissions documented in the "MSSQLServer Service and SQL Executive Requirements" topic of the SQL Server Books Online. You can find this topic in Part 2, "What's New for Setup," of the "What's New in SQL Server 6.5" book, under "Platform Support" and "Running on Windows NT 3.51 or Later."
To work around this problem for CmdExec tasks, use either of the following methods:
- If the task can be owned by the SA, re-create the task using an SA login.
- Re-create the permissions on the SQL Executive service account by using the following steps:
- Use SQL Enterprise Manager to set up the SQL Executive service to run under the same account again, which will reset the permissions required.
- Stop and restart the SQL Executive service.
To work around this problem for xp_cmdshell, use either of the following methods:
- Disable the "xp_cmdshell - Use SQLExecutiveCmdExec Account for Non SAs" option in SQL Enterprise Manager or SQL Setup.
- Re-create the permissions on the SQL Server service account by using the following steps:
- Use SQL Enterprise Manager to set up the SQL Executive service to run under the account that the MSSQLServer service is running under, which will reset the permissions required.
- Change the SQL Executive service back to its original account.
- Stop and restart the MSSQLServer service.
Additional query words: SQLExecutive
Keywords: kbenv kbprb kbusage KB171291