Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 883551 - Last Review: October 28, 2004 - Revision: 1.1
You may receive the "Error 8198 the job failed†error message on a computer that is running SQL Server Agent jobs that are installed by BizTalk Server 2004
When one or more of the SQL Server Agent jobs that are installed by Microsoft BizTalk Server 2004 fail, you receive an error message that is similar to 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)).
This problem may occur when the job is owned by a Microsoft Windows 2000 authenticated user or by a Microsoft Windows Server 2003 authenticated user. Also, the problem occurs when the job is run from the one of the following:
- A local Windows 2000 administrator or a local Windows Server 2003 administrator
- A schedule, after being scheduled
To resolve this problem, change the job owner to a standard SQL Server user or to a standard SQL Server system administrator. To do this, follow these steps:
- Start SQL Server Enterprise Manager.
- Expand Microsoft SQL Servers, and then expand SQL Server Group.
- Expand your server name.
- Expand Management, and then expand SQL Server Agent.
- Click Jobs. In the right pane, right-click the job that failed, and then click Properties.
- In the Properties dialog box, click Owner on the General tab to display the list of owners.
- In the Owner list, click the SQL Server user who you want to use. Alternatively, click sa, and then click OK.
- When you are prompted to stop and to restart SQLAgent, click OK.
- Restart any instances of SQL Server.
Note We recommend that you also restart any other instances of SQL Server Agent that are installed on your server.
For additional information, click the following article numbers to view the articles in the Microsoft Knowledge Base:
241643Â
(http://kbalertz.com/Feedback.aspx?kbNumber=241643/
)
8198 error message returned from job owned by Windows NT authenticated user
834124Â
(http://kbalertz.com/Feedback.aspx?kbNumber=834124/
)
How to troubleshoot a SQL Server 8198 error
APPLIES TO
- Microsoft BizTalk Server 2004 Enterprise Edition
- Microsoft BizTalk Server 2004 Developer Edition
- Microsoft BizTalk Server 2004 Partner Edition
- Microsoft BizTalk Server 2004 Standard Edition
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate