Re: downloading files from another server through aspx

From: Wardeaux (wardeaux_at_bellsouth.net)
Date: 02/27/04 

Date: Fri, 27 Feb 2004 18:29:13 -0500

John,
  thanks for the reply. Any suggestions on good articles on setting up
"impersonation"... Installing IIS on the SQL box is a good suggestion, but
because of security requirements, we're not allowed to have both IIS and SQL
on the same box, (strange but true...)... anyways looks like impersonation
is a viable(?) option... any suggestions on articles and reading is most
appreciated! :)
many thanks!
wardeaux

"John Timney (Microsoft MVP)" <timneyj@despammed.com> wrote in message
news:%23r11PgY$DHA.3852@TK2MSFTNGP10.phx.gbl...
> Its a permissions problem. Your asp page would have to impersonate a user
> who could connect to that remote server to allow it to run as that user.
> Then your anonymous guests could access the remote server via the page
that
> is impersonating the privelaged user.
>
> Always a really tricky problem.
>
> Stating the obvious - why dont you just install IIS to the SQL box, or
> install something like tiny web server. Save yourself a lot of headaches.
>
> --
> Regards
>
> John Timney
> Microsoft Regional Director
> Microsoft MVP
>
>
> "Wardeaux" <wardeaux@bellsouth.net> wrote in message
> news:OuPaP2X$DHA.3256@TK2MSFTNGP09.phx.gbl...
> > Hey all,
> > I'm hitting a wall... We have many daily reports generated on another
> > server, need to present list of available files and allow user to
download
> > desired files from aspx page... any suggestions on how to do this? The
> > other server is running Win2K3 with SQL but no IIS... tried mapping
drives
> > and setting up shortcuts, nothing allows permissions from IIS_Guest
> > account...
> > even a "Can't Get there from here..." would be appreciated at this
point!
> >
> > many thanks in advance....
> > wardeaux
> >
> >
>
>

Relevant Pages

  • Re: missing indexes
    ... My sql version is: Microsoft SQL Server ... >I've simplified the query a little, but it's still causing the error in my ...
    (microsoft.public.sqlserver.programming)
  • Re: DTS and the Internet
    ... Unfortunately I am new to SQL and DTS thus I would need more guidance. ... For instance the only "add a connection" topic is related to ... >>Where and in what format should I declare to DTS the remote server. ...
    (microsoft.public.sqlserver.dts)
  • Re: How to protect my SQL Server queries
    ... If the remote server is part of the same domain, or a domain trust is setup ... then just use windows authentication to protect your credentials. ... In sql 2000 you can either do that via ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Where are server connections stored in project?
    ... SQL Instant on your PC at work, your laptop, and remote server. ... The above connection string will work with all three machines: ...
    (microsoft.public.dotnet.framework.adonet)
  • How do I install Component Services in Win2K without installing IIS 5?
    ... DBA is against installing IIS onto the Win2K box which has the SQL ... How do I go about installing Component Services in that box? ...
    (microsoft.public.inetserver.iis)