I did this , but even then it did not work.
Here is the details of scenario what I am having.
1) I have my SQL server (source of data) on domain A.
2) The network drive (say H drive), ie. the destination is
on domain B.
3) There is no trust relationship between domains A & B.
4) And I used an account of domain A , to run the SQL
server agent service, as this account has full permission
on the H drive.
5) The H drive was mapped on the source server , using the
same account.
How can I make it work in such a case.
Thanks for you help in advance.
V~
[quoted text, click to view] >-----Original Message-----
>Since all job which are scheduled are run by the SQL
Server Agent Service,
>ensure that you are running the Agent Service on a
Domain account which has
>all permissions on the mapped drive or the share while
using a UNC path.
>
>You can change this from Control Panel-->Admin Tools--
>Services
>
>--
>Regards,
>Mandar Naik
>
>
>This posting is provided AS IS with no warranties, and
confers no rights.
>"VChougule" <vchougule@gsionline.com> wrote in message
>news:0c8401c33c28$8c667870$a001280a@phx.gbl...
>> I also tried using the UNC path but still it does not
work.
>>
>> V~
>>
>> >-----Original Message-----
>> >I have a job in SQL Server 2000. The job selects data
>> from
>> >the SQL server(using a query) and writes it to a .dbf
>> file
>> >on a network drive.
>> >
>> >When I start the job / schedule it, the job history
shows
>> >that it has run successfully but it does not create or
>> >update the .dbf file. However if I write it to a local
>> >disk it succeeds. FYI - in the job history , in step
>> >details it shows "Could not open step output file. Step
>> >succeeded"
>> >
>> >Any help appreciated.
>> >
>> >Thanks in advance.
>> >V~
>> >
>> >.
>> >
>
>
>.
Since all job which are scheduled are run by the SQL Server Agent Service,
ensure that you are running the Agent Service on a Domain account which has
all permissions on the mapped drive or the share while using a UNC path.
You can change this from Control Panel-->Admin Tools-->Services
--
Regards,
Mandar Naik
This posting is provided AS IS with no warranties, and confers no rights.
[quoted text, click to view] "VChougule" <vchougule@gsionline.com> wrote in message
news:0c8401c33c28$8c667870$a001280a@phx.gbl...
> I also tried using the UNC path but still it does not work.
>
> V~
>
> >-----Original Message-----
> >I have a job in SQL Server 2000. The job selects data
> from
> >the SQL server(using a query) and writes it to a .dbf
> file
> >on a network drive.
> >
> >When I start the job / schedule it, the job history shows
> >that it has run successfully but it does not create or
> >update the .dbf file. However if I write it to a local
> >disk it succeeds. FYI - in the job history , in step
> >details it shows "Could not open step output file. Step
> >succeeded"
> >
> >Any help appreciated.
> >
> >Thanks in advance.
> >V~
> >
> >.
> >
