June 12, 2007 at 2:31 pm
I am running into an error when running a package using a scheduled job under SQL Server Agent account. I am getting following error:
Date 6/12/2007 4:19:15 PM
Log Job History (VistaODSFeed)
Step ID 0
Server 006-DEVSQL2005
Job Name VistaODSFeed
Step Name (Job outcome)
Duration 00:00:00
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0
Message
The job failed. Unable to determine if the owner (ACI\snasir) of job VistaODSFeed has server access (reason: Could not obtain information about Windows NT group/user 'ACI\snasir', error code 0x6ba. [SQLSTATE 42000] (Error 15404)).
ACI\snasir is not the account under which SQL Server Agent service runs. However ACI\snasir has sa priveleges. not sure why am I getting ACI\snasir in the error and not the account under which sql server agent runs.
ideas?
June 12, 2007 at 9:41 pm
Hi Dude,
From the job history info it seems ACI\snasir is the owner of the job.But u say that sqlserver agent seems to run in different account name.So y dont u try changing the job owner as sql agent name and execute the job.Also did u check if the job owner ACI\snasir has sufficient permissions???.
Guess its trying to access some unauthorized folder,can u be more specific as to wat the job is calling which folder etc........
[font="Verdana"]- Deepak[/font]
June 15, 2007 at 4:56 am
In 2005 you have something called as file storage type and server storage type. If the DTS is stored as file storage type the owner of the SSIS package can execute it as a job successfully where as other users can't execute the same. Ask the SSIS package owner to place the package in SQL Server with type server storage.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply