We have an ASP.NET application that attempts to access an Excel file located
on a remote file server. This always results in a logon error, but if we mov
e
the Excel file locally to the IIS server, we are able to access it without a
problem.

We are running on an IIS 6/Windows 2003 server and the remote file server is
also a Windows 2003 box on the same domain.

We went through all the steps indicated in the KB article 253580 "How to
connect to a remote Access database from Active Server Pages" without succes
s:

1) Modified the Anonymous account to a local/domain administrator account
that also exists on the remote server (passwords match)

2) Used Basic authentication

3) Used Windows Integrated authentication

4) Gave full rights to the file on the remote server

This is obviously an access issue because once we move the file locally,
everything is fine and dandy but we have been unable to determine what
account should be given rights.

At this point we are stumped by what else to do. Any suggestions or ideas
would be very helpful.

[ Post a follow-up to this message ]

"itmanager" <itmanager@discussions.microsoft.com> wrote in message
news:FE5135B4-DE1C-47A8-84F3-4B3713B9FE9F@microsoft.com...
> We have an ASP.NET application that attempts to access an Excel file
> located
> on a remote file server. This always results in a logon error, but if we
> move
> the Excel file locally to the IIS server, we are able to access it without
> a
> problem.
>
> We are running on an IIS 6/Windows 2003 server and the remote file server
> is
> also a Windows 2003 box on the same domain.
>
> We went through all the steps indicated in the KB article 253580 "How to
> connect to a remote Access database from Active Server Pages" without
> success:
>
> 1) Modified the Anonymous account to a local/domain administrator account
> that also exists on the remote server (passwords match)
>
> 2) Used Basic authentication
>
> 3) Used Windows Integrated authentication
>
> 4) Gave full rights to the file on the remote server
>
> This is obviously an access issue because once we move the file locally,
> everything is fine and dandy but we have been unable to determine what
> account should be given rights.
>
> At this point we are stumped by what else to do. Any suggestions or ideas
> would be very helpful.

Since you're using ASP.NET this will be a better guide then the ASP article:
http://support.microsoft.com/defaul...kb;en-us;317012

--
Tom Kaminski IIS MVP
http://www.microsoft.com/windowsser...ty/centers/iis/
http://mvp.support.microsoft.com/
http://www.iistoolshed.com/ - tools, scripts, and utilities for running IIS

[ Post a follow-up to this message ]

Thanks for the reply.

Although the application is ASP.NET, we are actually calling and accessing
the remote file using a classic .asp page. We tried running it outside of th
e
ASP.NET app and got the same results.

Any other suggestions?

"Tom Kaminski [MVP]" wrote:

> "itmanager" <itmanager@discussions.microsoft.com> wrote in message
> news:FE5135B4-DE1C-47A8-84F3-4B3713B9FE9F@microsoft.com... 
>
> Since you're using ASP.NET this will be a better guide then the ASP articl
e:
> http://support.microsoft.com/defaul...kb;en-us;317012
>
> --
> Tom Kaminski IIS MVP
> http://www.microsoft.com/windowsser...ty/centers/iis/
> http://mvp.support.microsoft.com/
> http://www.iistoolshed.com/ - tools, scripts, and utilities for running II
S
>
>
>

[ Post a follow-up to this message ]

De facto URL on how to access remote files/resources from IIS:
http://www.microsoft.com/technet/pr...s/remstorg.mspx

Out of the box, using anonymous and basic authentication just works with
minimal reconfiguration.

You need to clarify exactly WHAT identity is executing the ASP page.
http://blogs.msdn.com/david.wang/ar.../>
Part_2.aspx

--
//David
IIS
http://blogs.msdn.com/David.Wang
This posting is provided "AS IS" with no warranties, and confers no rights.
//
"itmanager" <itmanager@discussions.microsoft.com> wrote in message
news:39180482-62B0-4082-AD93-40E28CF0AABD@microsoft.com...
Thanks for the reply.

Although the application is ASP.NET, we are actually calling and accessing
the remote file using a classic .asp page. We tried running it outside of
the
ASP.NET app and got the same results.

Any other suggestions?

"Tom Kaminski [MVP]" wrote:

> "itmanager" <itmanager@discussions.microsoft.com> wrote in message
> news:FE5135B4-DE1C-47A8-84F3-4B3713B9FE9F@microsoft.com... 
without[vbcol=seagreen] 
server[vbcol=seagreen] 
account[vbcol=seagreen] 
ideas[vbcol=seagreen] 
>
> Since you're using ASP.NET this will be a better guide then the ASP
article:
> http://support.microsoft.com/defaul...kb;en-us;317012
>
> --
> Tom Kaminski IIS MVP
> http://www.microsoft.com/windowsser...ty/centers/iis/
> http://mvp.support.microsoft.com/
> http://www.iistoolshed.com/ - tools, scripts, and utilities for running
IIS
>
>
>

[ Post a follow-up to this message ]