Prev: Disable and Rebuild or Drop and recreate Index
Next: Read HTML File though Network for Email.
From: Erland Sommarskog on 6 May 2008 17:37
abhy (abhijit.dalvi29(a)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(a)sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
 | 
Pages: 1
Prev: Disable and Rebuild or Drop and recreate Index
Next: Read HTML File though Network for Email.