Page 1 of 4 123 ... LastLast
Results 1 to 15 of 48

Thread: IIS 6.0

  1. #1
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post

    IIS 6.0

    Hi,
    I'm trying to get into http://localhost/reports and I get this error:

    Failed to access IIS metabase.
    Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
    ----------------------------------------------------------------------------------------------------------------------------------------------
    Exception Details: System.Web.Hosting.HostingEnvironmentException: Failed to access IIS metabase.

    The process account used to run ASP.NET must have read access to the IIS metabase (e.g. IIS://servername/W3SVC). For information on modifying metabase permissions, please see http://support.microsoft.com/?kbid=267904.
    ---------------------------------------------------------------------------------------------------------------------------------

    I went to the microsoft link and followed the help files but nothing has worked. I uninstalled and reinstalled sql server 2005 express edition but still get the error. I'm not sure what to look for or do next.

    Thanks,
    Leesha

  2. #2
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newark, New Jersey, USA
    Posts
    999
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: IIS 6.0

    Mike Wolfman
    Jack of all, Master of none
    Bow before me, for I am root.
    <IMG SRC=http://www.wopr.com/w3tfiles/112673-wolfsig.jpg>

  3. #3
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: IIS 6.0

    Hi Mike,

    I tried these links and got through the error and now have this one when I load http://localhost/records

    The request failed with HTTP status 401: Unauthorized

    I've checked all the permissions and they seem appropriate. I spent the morning searching the internet for a clue and although there area lot of posts, I couldn't find anything that helped other than looking at permissions.

    Thanks,
    Leesha

  4. #4
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newark, New Jersey, USA
    Posts
    999
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: IIS 6.0

    What is the default file in the directory records? index.htm* index.asp?
    Mike Wolfman
    Jack of all, Master of none
    Bow before me, for I am root.
    <IMG SRC=http://www.wopr.com/w3tfiles/112673-wolfsig.jpg>

  5. #5
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: IIS 6.0

    OK, now don't laugh, but I don't think I have one. When I go to the default web site in IIS, I don't have a default file or home page. I haven't created one there and the MSDN tutorial didn't have me create one. When I go to www.root in C:/inetpub I don't have one there either.

    Leesha

  6. #6
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newark, New Jersey, USA
    Posts
    999
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: IIS 6.0

    ok, so, whats in /records that your supposed to see when you go to it? If you want a quick test, open notepad and enter this:

    <html><body>
    <center><h1>Test</h1></center>
    </body></html>

    then save it as index.htm or default.htm and put it in the records directory. When you go there, you should see 'Test' on screen. If this works, you need some default file in the records directory.

    Note: make sure there's no default.htm or index.htm in the directory before you put the test file in there.
    Mike Wolfman
    Jack of all, Master of none
    Bow before me, for I am root.
    <IMG SRC=http://www.wopr.com/w3tfiles/112673-wolfsig.jpg>

  7. #7
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: IIS 6.0

    >>ok, so, whats in /records that your supposed to see when you go to it? If you want a quick test, open notepad and enter this:

    I don't honestly know in that I'm simply following a msdn video tutorial and I get the error. When I checked in the records folder I have home.aspx. According the the tutorial, after I set my report services configuration in sql server 2005 configuration tools, I should be able to go to IE and type in http://localhost/reports and the the age will load. It will be blank as there are no reports in it yet. Later in the tutorial, after I've completed a report, If I go back to this address I'll see the report, be able to open it etc. I'm attaching a screen shot of what I get. I noted that the IP address changes to http://localhost/reports/pages/folder.aspx. I'm not sure why this is however I went to the folder.aspx file and made sure that the permissions is set to anonymous and it is. I'm not sure what is going on.



    <html><body>
    <center><h1>Test</h1></center>
    </body></html>

    then save it as index.htm or default.htm and put it in the records directory. When you go there, you should see 'Test' on screen. If this works, you need some default file in the records directory.

    Note: make sure there's no default.htm or index.htm in the directory before you put the test file in there.
    Attached Images Attached Images

  8. #8
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newark, New Jersey, USA
    Posts
    999
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: IIS 6.0

    401 Unauthorized means the request requires user authentication. Somewhere, you have a permission issue. Are you setting the permissions in IIS and on the folder level? Its really hard to completely troubleshoot like this. I'd check all files and folders permissions in IIS and in NTFS. Try using the test file I put in my pervious post but rename it to test.htm.

    http://localhost/records/test.htm

    That should at least tell you if its a folder or file issue. Then go thru the NTFS And IIS permissions.
    Mike Wolfman
    Jack of all, Master of none
    Bow before me, for I am root.
    <IMG SRC=http://www.wopr.com/w3tfiles/112673-wolfsig.jpg>

  9. #9
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: IIS 6.0

    Thanks for sticking with me on this. At the risk of sounding really dense, how do I save the file to the IIS folders? I get to IIS by right clicking MyComputer and opening that way. However I don't have the option to paste or save a file there. Where on the C drive is it located or is it a virtual directory that I need to post a file to the way I would upload in Frontpage or FTP?

    Thanks,
    Alicia

  10. #10
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newark, New Jersey, USA
    Posts
    999
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: IIS 6.0

    Yes, its locted somewhere on a local drive. Without seeing it, its either under c:inetpub*** or the virtual IIS directory points to a place on a local drive. If I remember correctly, if you right click the virtual directory and go into the properties, it should give a location on your drive. The easiest way is to do a search for one of the aspx files.
    Mike Wolfman
    Jack of all, Master of none
    Bow before me, for I am root.
    <IMG SRC=http://www.wopr.com/w3tfiles/112673-wolfsig.jpg>

  11. #11
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    1,862
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: IIS 6.0

    Hi Leesha,

    I think you're heading down the wrong path. Microsoft SQL Reporting Services is the tool that you're working with here - it is what controls the access to the /Reports folder.

    Generally speaking, SQL Reporting Services uses Active Directory permissions to allow or deny access to its respective folders and reports. Your best bet would be to search for advice on administering SQL Reporting Services.

  12. #12
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: IIS 6.0

    I'm soooo confused! I did a search on administering SQL Reporting Services as you suggested and the information (like everything else I found on the internet for a 401 error) points to administrative privileges on the computer that the service is hosted on. Since this is on my local computer, not a web server, and I am logged in as myself, with adminstrative privileges I do not understand why I'm getting a authorization error. I've gone so far as to set every file and folder in the IIS directory as anonymous users allowed and even with that can't get. For the life of me I can "find" the virtual "reports" folder on my c:drive unless I look at it through mycomputer/manage and that doesn't appear to allow me to create or paste a file to test the file mentioned by Mike. This is like trying to find a needle in a haystack.

    Leesha

  13. #13
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newark, New Jersey, USA
    Posts
    999
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: IIS 6.0

    Not being a DBA - is the reports folder on the sql server? In IIS, whats the properties windows for Reports say?
    Mike Wolfman
    Jack of all, Master of none
    Bow before me, for I am root.
    <IMG SRC=http://www.wopr.com/w3tfiles/112673-wolfsig.jpg>

  14. #14
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: IIS 6.0

    I'm uploading screen shots as well as the web config files.

    Leesha
    Attached Files Attached Files

  15. #15
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newark, New Jersey, USA
    Posts
    999
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: IIS 6.0

    In the IIS Prop 2, whats the entire 'local directory'
    Mike Wolfman
    Jack of all, Master of none
    Bow before me, for I am root.
    <IMG SRC=http://www.wopr.com/w3tfiles/112673-wolfsig.jpg>

Page 1 of 4 123 ... LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •