473,549 Members | 2,726 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

SQL Job failing error 8198

When a SQL job has been created to run a local DTS package it fails
with the following error message.

The job failed. Unable to determine if the owner
(DomainName\Use rAccount) of job MyJobName has server access (reason:
Could not obtain information about Windows NT group/user '
DomainName\User Account'. [SQLSTATE 42000] (Error 8198)).

The package runs if executed from the DTS Local Packages in Enterprise

I have seen other articles about changing the owner to SA, this would
not work as a domain account is required to connect to a network share.

How can I get the SQL Job to run as a domain account?

Jul 23 '05 #1
4 9608
You don't give any information about your domain, but there are a
couple of KB articles which might be relevant:


If this doesn't help, I suggest you give some more information - what
MSSQL version, what OS version, what domain setup, what account is SQL
Agent running under, etc. By the way, running a job as sa has nothing
to do with accessing a network share - that depends on the SQL Agent
service account, so assuming that your service account is a domain one
with access to the share, you should probably try it anyway.


Jul 23 '05 #2
I have found the problem is the SQL Agent service account is a local
account. This is on a SQL Server 2000 SP3, Windows 2000 and Windows
Active Directory domain.
What permissions are required for a domain account to run as the SQL
Agent service account?

Jul 23 '05 #3
See "Setting up Windows Services Accounts" in Books Online.


Jul 23 '05 #4
3 New Member
hi robin,
When a SQL job has been created to run a local DTS package as per schedule it fails with the following error message.

The job failed. Unable to determine if the owner
(DomainName\Use rAccount) of job MyJobName has server access (reason:
Could not obtain information about Windows NT group/user '
DomainName\User Account'. [SQLSTATE 42000] (Error 8198)).

found ur post ..
how did u solve the problem
can u assist me as i am new into batch job maintanence activity
thank u
vignesh kannan
vigneshblue@gma il.com
Apr 26 '06 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

by: Simon Stewart | last post by:
Has anyone else experience of imagecreatefromjpeg failing with an error message about memory even though the size of the image being uploaded is nothing like the space available to the script? Is imagecreatefromjpeg particularly memory hungry? Immediately prior to the failure memory is given as 2405072 The jpeg being uploaded is 812201 in...
by: Chris Curvey | last post by:
I've looked at this so long that I must be looking right past it. This code: class Page: ########################################################## def write(self, value, row=None, col=None, len=None): print isinstance(value, str) # error occurs on this line print len(value)
by: Sundeep Gawande | last post by:
I am facing a strange problem. I am trying to host a .NET(C#) control in a VC6 COM ocx. Now when I create the control using CreateControl(...) or CoCreateInstance(...) my call is failing with the error module not found. The .NET control was having some std. controls like buttons and text boxes in it. Now I removed all these controls and...
by: zzapper | last post by:
Hi, If I make a mistake designing a JavaScript Form Checker, ie get the name (or case) of a form Field wrong, JavaScript seems to default to immediately returning true and the form is submitted even though incomplete. This makes debugging difficult. Can any of the grey matter here advise on how to get round this, any tips etc. zzapper...
by: Chris Marsh | last post by:
Help... I am receiving this error "550 5.7.1 Unable to relay for synergytestacct@yahoo.com" when I try to send outside email directly from the website project. Keep in mind this works fine for local addresses within our domain but it is failing for outside address such as the example above. I created the above account for testing, I can...
by: Vijayakrishna Pondala | last post by:
Hi, We are using the following error randomly, when accessing a webservice method/servlet hosted on JBoss application server: The underlying connection was closed: An unexpected error occurred on a receive. We are using .NET v1.1.
by: vigneshkannan | last post by:
When a SQL job has been scheduled to run a DTS package automatically it fails with the following error message. The job failed. Unable to determine if the owner (DomainName\UserAccount) of job MyJobName has server access (reason: Could not obtain information about Windows NT group/user ' DomainName\UserAccount'. (Error 8198)). The...
by: filmo | last post by:
I've got a script that is receiving a PUT request from a Java Applet. To access the PUT data, the php script contains: $putdata = fopen("php://input","r"); error_log("PUTDATA = $putdata Last Err: $php_errormsg"); On our development server, it works fine (Mac OS X 10.3.9 with PHP 4.3.6)
by: David Greenberg | last post by:
Hello I am running a DTS (Sql 2000) and transfering data from an SqlServer database to an Ingres database. I am transfering 153k rows. Execution fails with the error message: "The number of failing rows exceeded the maximum specified" The number of rows shouldn't be a problem because in another DTS I copy a lot more rows. Also the width...
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.