Unix Technical Forum

Read HTML File though Network for Email.

This is a discussion on Read HTML File though Network for Email. within the SQL Server forums, part of the Microsoft SQL Server category; --> Hello, I am using SQL server 2000. I have created 1 folder contains HTML files, which resids on IIS ...


Go Back   Unix Technical Forum > Database Server Software > Microsoft SQL Server > SQL Server

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 05-07-2008, 11:15 AM
abhy
 
Posts: n/a
Default Read HTML File though Network for Email.

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.

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 05-07-2008, 11:15 AM
Erland Sommarskog
 
Posts: n/a
Default Re: Read HTML File though Network for Email.

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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 05:10 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0
www.UnixAdminTalk.com