The postings on this site are my own and do not represent my Employer's positions, advice or strategies.

LifeAsBob

  Sunday, July 22, 2018

 


Home
Blog
bob tech
Calendar
Contact Bob
Pictures
VW Buses
HomeBrew
Cook Book

 

AJH - 1st Year

  bob Links
Q224071 - INF Moving...
I have total irreverence for anything connected with society, except that which makes the road safer, the beer stronger, and the old men and women warmer in the winter and happier in the summer. - Brendan Behan
Wider View Insert

Cluster
DOS
IBM - AS400
MOM
Performance Counters
Service Broker
SQL Server
     Temporary Database
     Views
     Backup
     SQL Mail
     DTS - Data Transformation Services
     Memory
     Security
     Excel
     Jobs SQL Agent
          PRB: 8198 Error Mess...
     MSDE
     Install
     DBCC
     User Management
     System Databases
     BCV
     Deadlocks
     Temp Tables
Windows OS

Insert Category

Will be added as a sub-category of, Jobs SQL Agent
PRB: 8198 Error Message Returned from Job Owned by Windows NT Authenticated User
http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q241/6/43.asp&NoWebContent=1 PRB: 8198 Error Message Returned from Job Owned by Windows NT Authenticated User View products that this article applies to. This article was previously published under Q241643 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 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). The information in this article applies to: Microsoft SQL Server 2000 (all editions) Microsoft SQL Server 7.0 Last Reviewed: 9/16/2003 (4.0) Keywords: kbBug kbpending kbprb KB241643