.iqy file produces error 404 3 50

I am trying to run a web solution that has run fine on Windows 2000 Server.
The solution generates reports that are opened using Excel. The file that
Excel is opening is an .iqy file (Excel Internet Web Query?). There is a
problem with Windows Server 2003. When I try to open the iqy files, I get a
404 (File or folder not found) error. In the IIS log the following entry i s
found:

2005-04-12 10:48:49 10.0.42.197 GET
/webquery/4c43aad5-ba82-4b63-afdb-218b7755169f.iqy - 80
VPC-GAUP-W2K3\administrator 10.0.42.133
Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.NET +CLR+1.0.3705)
404 3 50

It tells me the following:
sc-status = 404 (File not found)
sc-substatus = 3
sc-win32-status = 50

I have enabled Directory Browsing, but I still get the error, even though I
am clicking on the file that is shown to be, in fact, there in the
directory. This is driving me nuts!

I have also registered the MIME type .icy on the server in IIS Explorer. It
didnt't help.

Thanks in advance for any help on this problem...

Sincerely
Svein Terje Gaup

Re: .iqy file produces error 404 3 50

I've come a little bit further now. It turns out, when I set Default
Application Pool to run as Local System in stead of Network Service, things
are working as they should. I am going to try to give the Network Service
account some more priveleges on the folder containing the query files, and
see if it helps.

Sincerely
Svein Terje Gaup

"Svein Terje Gaup" wrote in message
news:eRxV4O1PFHA.3596@TK2MSFTNGP15.phx.gbl...
>I am trying to run a web solution that has run fine on Windows 2000 Server.
>The solution generates reports that are opened using Excel. The file that
>Excel is opening is an .iqy file (Excel Internet Web Query?). There is a
>problem with Windows Server 2003. When I try to open the iqy files, I get a
>404 (File or folder not found) error. In the IIS log the following entry i
>s found:
>
> 2005-04-12 10:48:49 10.0.42.197 GET
> /webquery/4c43aad5-ba82-4b63-afdb-218b7755169f.iqy - 80
> VPC-GAUP-W2K3\administrator 10.0.42.133
> Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.NET +CLR+1.0.3705)
> 404 3 50
>
> It tells me the following:
> sc-status = 404 (File not found)
> sc-substatus = 3
> sc-win32-status = 50
>
> I have enabled Directory Browsing, but I still get the error, even though
> I am clicking on the file that is shown to be, in fact, there in the
> directory. This is driving me nuts!
>
> I have also registered the MIME type .icy on the server in IIS Explorer.
> It didnt't help.
>
> Thanks in advance for any help on this problem...
>
> Sincerely
> Svein Terje Gaup
>
>
>
>

Re: .iqy file produces error 404 3 50

Everything you described is working and by-design. You need to read basic
in-box IIS documentation for the details.

404 3 50 means that the .iqy file did not have a MIME Type set for the .iqy
extension, so IIS is disallowing access to it by returning 404. If you added
a MIME Type, it should then be downloadable. Remember that if you set it at
the global level (and not per-website/vdir), you need to restart IIS to pick
up the changes.

Directory Browsing has nothing to do with this since it determines server
behavior when a Default Document is not found/defined. It has no relation to
whether a resource is allowed to be downloaded or not.

You also do not need to change Application Pool identity nor change
permissions of Network Service -- it should work by default if you configure
IIS correctly.

--
//David
IIS
http://blogs.msdn.com/David.Wang
This posting is provided "AS IS" with no warranties, and confers no rights.
//
"Svein Terje Gaup" wrote in message
news:OFUGrc1PFHA.3788@tk2msftngp13.phx.gbl...
I've come a little bit further now. It turns out, when I set Default
Application Pool to run as Local System in stead of Network Service, things
are working as they should. I am going to try to give the Network Service
account some more priveleges on the folder containing the query files, and
see if it helps.

Sincerely
Svein Terje Gaup

"Svein Terje Gaup" wrote in message
news:eRxV4O1PFHA.3596@TK2MSFTNGP15.phx.gbl...
>I am trying to run a web solution that has run fine on Windows 2000 Server.
>The solution generates reports that are opened using Excel. The file that
>Excel is opening is an .iqy file (Excel Internet Web Query?). There is a
>problem with Windows Server 2003. When I try to open the iqy files, I get a
>404 (File or folder not found) error. In the IIS log the following entry i
>s found:
>
> 2005-04-12 10:48:49 10.0.42.197 GET
> /webquery/4c43aad5-ba82-4b63-afdb-218b7755169f.iqy - 80
> VPC-GAUP-W2K3\administrator 10.0.42.133
> Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.NET +CLR+1.0.3705)
> 404 3 50
>
> It tells me the following:
> sc-status = 404 (File not found)
> sc-substatus = 3
> sc-win32-status = 50
>
> I have enabled Directory Browsing, but I still get the error, even though
> I am clicking on the file that is shown to be, in fact, there in the
> directory. This is driving me nuts!
>
> I have also registered the MIME type .icy on the server in IIS Explorer.
> It didnt't help.
>
> Thanks in advance for any help on this problem...
>
> Sincerely
> Svein Terje Gaup
>
>
>
>