Hello,
I am using SQL server 2000. I have created 1 folder contains HTML
files, which resids on IIS on one machin.
And my SQL server 2000 is on another machin.
I have created SP which reads file very well if the Files are stored
on same machin on which SQL erver was. But if Files are stored on
another Machin (files and SQl server are resids on two different
machin) then it gives error like NetworkPath not existed. Even path is
ok.
What are the changes has to be made so that SQL server can access
files from another servert.
Thanks in advance.

abhy (abhijit.dalvi29@gmail.com) writes:
> I am using SQL server 2000. I have created 1 folder contains HTML
> files, which resids on IIS on one machin.
> And my SQL server 2000 is on another machin.
> I have created SP which reads file very well if the Files are stored
> on same machin on which SQL erver was. But if Files are stored on
> another Machin (files and SQl server are resids on two different
> machin) then it gives error like NetworkPath not existed. Even path is
> ok.
> What are the changes has to be made so that SQL server can access
> files from another servert.

It sounds as if the service account for SQL Server is Local System.
Local System cannot access network devices.

Change the service account to a regular domain account. Right-click
on My Computer, select Manage. Find the Service applet. Find the
SQL Server service, right-click and select Properties. On the Log On
tab, you can change the service accounts.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx