Belificus
asked on
Trouble scheduling DTS to run.
I am confused about scheduling a DTS to run using Server Agent. Server agent service runs under local system account.
I have a DTS that when I open and choose Execute runs fine.
I logged on as sql admin and created a new DTS using my AD account. When is it scheduled to run I get back an error
The job failed. Unable to determine if the owner (AD\User) of job SW_to_DB has server access (reason: Could not obtain information about Windows NT group/user 'AD\User'. [SQLSTATE 42000] (Error 8198)).
so it sounds like the service cannot access the AD. Not sure what to do about that.
So I tried switching the job owner to a local account that I know has access to that DB. When I do that it does not run at all. I just get:
The job failed. The Job was invoked by Schedule 33 (SW_to_DB ). The last step to run was step 1 (SW_to_DB ).
I just want to schedule the DTS to run - but I am not sure where to chase this error.
I have a DTS that when I open and choose Execute runs fine.
I logged on as sql admin and created a new DTS using my AD account. When is it scheduled to run I get back an error
The job failed. Unable to determine if the owner (AD\User) of job SW_to_DB has server access (reason: Could not obtain information about Windows NT group/user 'AD\User'. [SQLSTATE 42000] (Error 8198)).
so it sounds like the service cannot access the AD. Not sure what to do about that.
So I tried switching the job owner to a local account that I know has access to that DB. When I do that it does not run at all. I just get:
The job failed. The Job was invoked by Schedule 33 (SW_to_DB ). The last step to run was step 1 (SW_to_DB ).
I just want to schedule the DTS to run - but I am not sure where to chase this error.
can you change the sql server agent to run as a domain admin account and also the job to run as the same account and see if that works. also make sure if the job is trying to access any files/folders this doman account needs permission to those too.
ASKER
dtodd - local service account.
uday - I do not want a domain servcie account with domain admin privledges.
There is a DTS present that was written by a thrid party vendor and THAT dts will run when scheduled.
Just not sure why.
uday - I do not want a domain servcie account with domain admin privledges.
There is a DTS present that was written by a thrid party vendor and THAT dts will run when scheduled.
Just not sure why.
Hi Belificus,
Why not a domain account? Surely you can create one with minimal priviledges? It doesn't have to be a domain admin account.
What we are suggesting is that it is easier to maniplulate a domain account and give it rights to different parts of the server, whereas I'd be a little more hesitant to do so with the local system account.
Regards
David
Why not a domain account? Surely you can create one with minimal priviledges? It doesn't have to be a domain admin account.
What we are suggesting is that it is easier to maniplulate a domain account and give it rights to different parts of the server, whereas I'd be a little more hesitant to do so with the local system account.
Regards
David
ASKER
Ok - creating a domain account now and setting privlidges.
Be back soon.
Thank you folks for helping me through this!
Be back soon.
Thank you folks for helping me through this!
ASKER
Interestingly enough, you guys are helping me find the problem in a round about way.
Turns out there is a DNS issue with this machine.
More to follow.
Turns out there is a DNS issue with this machine.
More to follow.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I am planning on moving to SQL 2005 anyway, so the machine will get whacked soon enough.
Well, here's what I have now. The revrse lookup for the subnet was added, but that did not help.
I had been scheduling jobs by right clicking on a DTS and choosing schedule. This left me as the owner.
So, I opened up that job and copied the DTS ID.
Then I created a new job, set an SQL account as the owner, pasted the DTS ID and typed in the rest.
Runs like a champ.
I realize that I am NOT addressing the real issue here, but it works and I agree with dtodd that adding the machine back may work. flushdns & registerdns did not help.
Anyway - THANK YOU for helping me dtodd and sticking with this issue. I'd like to give you the points.
Cheers,
Douglas
Well, here's what I have now. The revrse lookup for the subnet was added, but that did not help.
I had been scheduling jobs by right clicking on a DTS and choosing schedule. This left me as the owner.
So, I opened up that job and copied the DTS ID.
Then I created a new job, set an SQL account as the owner, pasted the DTS ID and typed in the rest.
Runs like a champ.
I realize that I am NOT addressing the real issue here, but it works and I agree with dtodd that adding the machine back may work. flushdns & registerdns did not help.
Anyway - THANK YOU for helping me dtodd and sticking with this issue. I'd like to give you the points.
Cheers,
Douglas
What account does SQL run under?
Regards
David