The information in this article applies to:
BUG #: 16244 (6.5) SYMPTOMS
If a non-system administrator (SA) login runs the extended stored procedure
xp_cmdshell on a domain controller when the option "xp_cmdshell - Use
SQLExecutiveCmdExec Account for Non SAs" is enabled in SQL Enterprise
Manager or SQL Server Setup under Set Server Options, the following error
will occur:
WORKAROUND
To work around this problem, do one of the following:
STATUSMicrosoft has confirmed this to be a problem in SQL Server
version 6.5. This problem has been corrected in U.S. Service Pack 5a
for Microsoft SQL Server version 6.5. For information about
downloading and installing the latest SQL Server Service Pack, see
http://support.microsoft.com/support/sql/.
MORE INFORMATION
Microsoft SQL Server 6.5 is not recommended for installation on a primary
domain controller (PDC) or a backup domain controller (BDC), because those
computers perform the resource-intensive tasks of maintaining and
replicating the domain's security accounts database and performing network
logon authentications.
Additionally, a similar error occurs with CmdExec tasks created by non-SA logins. For more information please see the following article in the Microsoft Knowledge Base: Q159792 : FIX: Non-SA CmdExec Task Run on Domain Controller Causes Error Additional query words: CmdExec Task SQLExecutive privilege
Keywords : kbusage SSrvAdmin SSrvGen kbbug6.50 kbfix6.50.SP5 |
Last Reviewed: November 17, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |