PRB: 8198 Error Message Returned from Job Owned by Windows NT Authenticated User

Article translations Article translations
Article ID: 241643 - View products that this article applies to.
This article was previously published under Q241643
Expand all | Collapse all

SYMPTOMS

On a Windows 2000 native domain that does not have a "Pre-Windows 2000 Compatible Access Group," and where the MSSQLServer service is run under the local system account, if a job is owned by a Microsoft Windows NT authenticated user, the following error message might occur when the job is run from a local Windows NT administrator or after being scheduled. Reviewing the job history displays the following error message:
The job failed. Unable to determine if the owner (domain\username) of job testjob has server access (reason: Could not obtain information about Windows NT group/user 'domain\username'. [SQLSTATE 42000] (Error 8198)).
Reviewing the SQLAgent errorlog shows an additional error message:
[298] SQLServer Error: 8198, Could not obtain information about Windows NT group/user 'domain\username'. [SQLSTATE 42000] (ConnIsLoginSysAdmin)
The extended stored procedure xp_logininfo 'domain\username' is being called which returns this error message:
Server: Msg 8198, Level 16, State 8, Procedure xp_logininfo, Line 58
Could not obtain information about Windows NT group/user 'domain\username'.

WORKAROUND

To work around this problem either:
  • Change the job owner to a standard SQL Server user or system administrator (sa).

    -or-

  • Upgrade to Microsoft Windows 2000 and add the Pre-Windows 2000 Compatible Access Group. Next, add the Everyone group to the Pre-Windows 2000 Compatible Access Group.


For more information, click the following article number to view the article in the Microsoft Knowledge Base:
303973 HOW TO: Add Users to Pre-Windows 2000 Compatible Access Group

STATUS

By design, Windows 2000 security changes now prevent access to resources that legacy applications (such as SQL Server 7.0) once could successfully access (for example, in Windows NT 4.0).

Properties

Article ID: 241643 - Last Review: November 27, 2006 - Revision: 6.2
APPLIES TO
  • Microsoft SQL Server 2000 Standard Edition
  • Microsoft SQL Server 7.0 Standard Edition
Keywords: 
kbbug kbpending kbprb KB241643

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com