SYMPTOMS
On a Windows 2000 native domain that does not have a "Pre-Windows 2000 Compatible Access Group", 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 additional information, click the article number below
to view the article in the Microsoft Knowledge Base:
303973 HOW TO: Add Users to Pre-Windows 2000 Compatible Access Group