Article ID: 159792
Article Last Modified on 6/30/2006
APPLIES TO
- Microsoft SQL Server 6.5 Standard Edition
This article was previously published under Q159792
BUG #: 17065 (6.5)
SYMPTOMS
If a non-system administrator (SA) login creates and runs a CmdExec task on
a domain controller, the following error will occur in both the task
history and the Application log of Windows NT's Event Viewer:
A problem occurred while attempting to logon as the Windows NT user
'SQLExecutiveCmdExec': Logon failure: unknown user name or bad password.
WORKAROUND
To work around this problem, do one of the following:
- Rename the machine name of the domain controller to match the domain
name. Note that this solution will only work for one SQL Server on a domain.
- Reinstall Windows NT Server as a server in the domain, instead of as a
domain controller.
- Run a Transact-SQL task that runs xp_cmdshell after installing Service Pack 5a for Microsoft SQL Server 6.5.
STATUS
Microsoft has confirmed this to be a problem in Microsoft SQL Server
version 6.5. We are researching this problem and will post new information
here in the Microsoft Knowledge Base as it becomes available.
Additional query words: 1326 privilege tsql t-sql trans-sql
Keywords: kbbug kbother KB159792