« Previous Next »

Thread: MOM Reporting Permissions Error

Last post 01-05-2009 6:44 AM by Paul Lynch. 3 replies.

Average Rating Rate It (5)

RSS

Page 1 of 1 (4 items)

Sort Posts:

Shortcuts

Search | Active Posts | Unanswered Posts | View all users

  • 12-17-2008, 9:24 PM

    • Bouffont
    • Not Ranked
    • Joined on 12-18-2008, 1:38 AM
    • Posts 2

    MOM Reporting Permissions Error

    Reply Contact
    Hi All,

    I have an issue with MOM reporting (which is actually just a bunch of reports added on to SQL reporting).

    When I first installed SQL reporting I couldn't use my account (which is a domain admin and a member of the local admins group) to access the site http://server1/reportserver. I would get "You are not authorized to view this page".

    I then went into IIS and set the security on the site to be anonymous rather than integrated which is what it was, did an iisreset and I could get into the site.

    However, when I try to run any report I get the "You are not authorized to view this page" page show up.

    So I thought I'd change the account used for anonymous access to my own account.

    This time I can get into the report and access all the different drop downs to change the report variables etc but i get the yellow warning icon show up on the IE toolbar that, when double clicked, says:

    Problems with this Web page might prevent it from being
    displayed properly or functioning properly. In the
    future, you can display this message by double-clicking
    the warning icon displayed in the status bar.

    Details:

    Line: 32
    Char: 2
    Error: Permission Denied
    Code: 0
    URL: http://server1.domain.internalQ/ReportServer?%2tMicrosoft+Operations+Manager+Reporting%2tMicrosoft+Operations+Manager%2fAgent+Configuration&PRIMARY=%3cALL%3e&Server=%3cALL%3e&SortBy=Server&Direction=Ascending&rs%3aCommand=Renser&rs%3aFormat=HTML4.0&rc%3aReplacementRoot=http%3a%2f%2fvserver1.domain.internal%2fReports%2fPages%2fReport.aspx%3fServerUrl%3d&rc%3aToolbar=True&rc%3aJavaScript=True&rc%3aLinkTarget=_top&rc%3aArea=Params

    When I try to run the report, nothing happens.

    So I'm figuring I need to give permssion to this account to use whatever the above blurb is.


    Can anyone point me in the direction of what permissions I should change, or what extra info will be needed to understand this.

    I installed filemon but have yet to unlock it's mysteries yet so using that would be a pain.

    Thanks for any help

    Tom

  • 12-17-2008, 11:02 PM In reply to

    Re: MOM Reporting Permissions Error

    Reply Contact

    Look at the IIS log file for the http error status codes. This will point you in the right direction initially.

    But I do not know if your application is meant to behave like this and you don't understand it or you have configured it wrong.

    http://www.iisportal.com

  • 01-04-2009, 8:24 PM In reply to

    • Bouffont
    • Not Ranked
    • Joined on 12-18-2008, 1:38 AM
    • Posts 2

    Re: MOM Reporting Permissions Error

    Reply Contact

     Hi,

     Thanks for the reply. The IIS logs show very little, all I get is a GET line:

     

    2009-01-05 01:16:18 W3SVC1 192.168.112.69 GET /ReportServer %2fMicrosoft+Operations+Manager+Reporting%2fMicrosoft+Windows+Base+Operating+System%2fPerformance+History%2fPerformance+History+Processor-Percent+Processor+Time&BeginDate=29%2f12%2f2008+11%3a16%3a27+AM&EndDate=5%2f01%2f2009+11%3a16%3a27+AM&rs%3aCommand=Render&rs%3aFormat=HTML4.0&rc%3aReplacementRoot=http%3a%2f%2fvmxmom01.virginblue.internal%2fReports%2fPages%2fReport.aspx%3fServerUrl%3d&rc%3aToolbar=True&rc%3aJavaScript=True&rc%3aLinkTarget=_top&rc%3aArea=Params 80 - 192.168.51.11 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.2;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727;+.NET+CLR+3.0.04506.30;+.NET+CLR+3.0.04506.648) 200 0 0
     

    Unfortunatley. This isn't much help.

    I put Filemon on and that was a bit cryptic too, but it got me thinking:

    The URL that's failing is:

     

    http://server1.domain.internalQ/ReportServer?%2tMicrosoft+Operations+Manager+Reporting%2 etc etc

     If we look at this part:

    /ReportServer?%2tMicrosoft+Operations+Manager+Reporting%2

    /ReportServer points to a location on the hard disk but there's nothing in there. Does the ? at the end denote something specific or should I be expecting a file or folder called /Microsoft Operations Manager Reporting etc?

     

    Thanks

     

     

  • 01-05-2009, 6:44 AM In reply to

    Re: MOM Reporting Permissions Error

    Reply Contact

    Bouffont:
    Hi All,

    When I first installed SQL reporting I couldn't use my account (which is a domain admin and a member of the local admins group) to access the site http://server1/reportserver. I would get "You are not authorized to view this page".

     

    Hi,

    This would indicate that SQL Reporting Services isn't setup correctly. Check that your application pool identity has got permission to read the SQL Reporting Services folders.

    Regards, 

    Paul Lynch | www.iisadmin.co.uk
Page 1 of 1 (4 items)
Microsoft Communities