|
Home > Archive > MS SQL Server > November 2006 > sql server job login user problem!!
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
sql server job login user problem!!
|
|
| nirnay4u@gmail.com 2006-11-28, 7:14 pm |
| hi,
Here is my problem,
The environment i m workin is sql server 2000 and .net 1.1
I have coded an executable which gets data from a web service.
To access the web service, I needed to install x509 security
certificate.
I have a DTS package running that executable.
When I run the dts package, it runs fine, but when i schedule job
and try to run that job,
the web service tells that access forbidden?
I tried sa and all other users to be owner of that job and ran the
job, but still no help.
I dont understand why its running fine with DTS and not the job.?
What user level the job runs?
Can I run the job as windows administrator ? How?
Please help. Thanks.
| |
| F_clef 2006-11-30, 7:14 pm |
| Does the account running the job have the appropriate permissions to the
file(s)/folder(s) in the package?
"nirnay4u@gmail.com" wrote:
> hi,
>
> Here is my problem,
> The environment i m workin is sql server 2000 and .net 1.1
>
> I have coded an executable which gets data from a web service.
> To access the web service, I needed to install x509 security
> certificate.
> I have a DTS package running that executable.
>
> When I run the dts package, it runs fine, but when i schedule job
> and try to run that job,
> the web service tells that access forbidden?
> I tried sa and all other users to be owner of that job and ran the
> job, but still no help.
>
> I dont understand why its running fine with DTS and not the job.?
> What user level the job runs?
> Can I run the job as windows administrator ? How?
>
> Please help. Thanks.
>
>
|
|
|
|
|