Solved

browsing .sql file giving 404 [IIS 6.0 on Win 2003]

Posted on 2004-04-16
5
377 Views
Last Modified: 2008-02-26
Environment : [IIS 6.0 on Win 2003]

Situation is like this:

i have several ".sql" files in one of my folder, say /usefulsql
this folder is accesible thru web by pointing my browser to:

http://mydomainname/usefulsql

[n.b. directory brosing is allowed for this folder in IIS]

Problem Statement :

but the problem is when i am opening one of the sql file say "1.sql"
i m getting 404 error.


My take:
1]
I am sure due to security reason or some s*it like that IIS is not fetching that file for me.
2]
On further R'nD i found that in Win 2003 "Find files or folder" if i specify
file named *.sql *containing text* - Insert it is returning me 0 files. but I
can clearly see sevral Insert writting in those sql file

when i changed the file ext of 1.sql to 1.txt it shows :

1 file *containing text* - Insert

so both of my findings suggest that win 2003 is treating .sql file is some
strange way, that is why it is not getting fetched by IIS and the text
written it is not getting searched by "Find files or folder"

- sandeepz_

p.s.
I went to
file explorer~tool~folder options~File types
and recreated the .sql and notepad assosiation but in vein

0
Comment
Question by:sandeepz_
5 Comments
 
LVL 2

Accepted Solution

by:
Psychotext earned 50 total points
ID: 10855004
You need to allow IIS 6 to handle this type of file extension as it's locked down by default.  Add a mime type to handle it.  You can do this in the following screen:

IIS Manager -->  Web Sites --> Your Website (Right click --> properties) --> HTTP Headers Tab -->  Mime Types (Click button)

Then add the "sql" extension with the description of your choice.  It'll display, if you want to save the file automatically there is a bit more work involved.
0
 

Author Comment

by:sandeepz_
ID: 10857646
thanks  Psychotext
its working superb!
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Logparser is the smartest tool I have ever used in parsing IIS log files and there are many interesting things I wanted to share with everyone one of the  real-world  scenario from my current project. Let's get started with  scenario - How do w…
If you don't have the right permissions set for your WordPress location in IIS, you won't be able to perform automatic updates. Here's how to fix the problem.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now