Re: Accessing remote files through IIS and web applications

From: Tom Kaminski [MVP] ((A_at_T))
Date: 11/16/05 

Date: Wed, 16 Nov 2005 16:10:53 -0500

"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/default.aspx?scid=kb;en-us;317012 

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

Relevant Pages

  • Re: RWW and Remote desktop stopped working on all clients
    ... After diggin through ALL the group policies, I found Remote ... Desktop DISABLED under the Account Lockout policy - I don't think I've even ... adminsitrator or another account with Domain Admin role; also the server ...
    (microsoft.public.windows.server.sbs)
  • Re: IIS 6 Directory Services Mapping ACL Problems
    ... It would appear that you can not delegate Certificate based credentials. ... IIS does not have the user's password, so it can't just logon to the remote ... file server as the user directly. ... Lastly - if you want to see what account is being used to access the remote ...
    (microsoft.public.inetserver.iis.security)
  • Re: asp.net remote [hosted] configuration usse
    ... That includes machine admin rights. ... to manipulate the that one site, one of many on a remote PC running Win2k3. ... The FrontPage Server Extensions Access Method ... Create an account on the remote Web Server. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • SecurityFocus Microsoft Newsletter #152
    ... MICROSOFT VULNERABILITY SUMMARY ... Real Networks Helix Universal Server Remote Buffer Overflow ... ... NEW PRODUCTS FOR MICROSOFT PLATFORMS ...
    (Focus-Microsoft)
  • Re: IIS 6.0 with Mapped Drives
    ... The user account that IIS is impersonating needs to have permissions to ... permissions to the remote resource. ... folder on local drive on the server, this local folder is Virtual Directory ...
    (microsoft.public.inetserver.iis)